Discussions

Expand all | Collapse all

mapd type error

  • 1.  mapd type error

    Posted 22 days ago
    Hi 
    i am getting this error  "Unable to process the queryTMapDException({ErrorMsg:Exception: Type not supported yet})"
     for certain queries but i have not used any type changes can you please help me to solve this
    #Core
    #Immerse


  • 2.  RE: mapd type error

    Posted 22 days ago
      |   view attached
    this is my query 


    Attachment(s)

    txt
    query.txt   2K 1 version


  • 3.  RE: mapd type error

    Posted 21 days ago
    Edited by Omnisci user 20 days ago
    Original Message:
    Sent: 12-28-2019 13:15
    From: Omnisci user
    Subject: mapd type error

    this is my query 


    Original Message:
    Sent: 12-28-2019 12:02
    From: Omnisci user
    Subject: mapd type error

    Hi 
    i am getting this error  "Unable to process the queryTMapDException({ErrorMsg:Exception: Type not supported yet})"
     for certain queries but i have not used any type changes can you please help me to solve this
    #Core
    #Immerse


  • 4.  RE: mapd type error

    Posted 21 days ago
    My best guess without any specific test is that some datatypes used by windows functions isn't supported


  • 5.  RE: mapd type error

    Posted 20 days ago
    Hi,

    I did a test and, as anticipated, the problem relies on string datatype you used in LEAD windows function for the order by. You can run the query using customer_id instead of the customer name, or another numerical datatype until this limit will be removed.