Discussions

Expand all | Collapse all

how to changes datatype

  • 1.  how to changes datatype

    Posted 29 days ago
    how to changes datatype of column in mapd client

    i need to change a column datatype of TEXT ENCODING DICT(32) to date 
    is there any alter command to change datatype of column
    #Core
    #Immerse


  • 2.  RE: how to changes datatype

    Posted 29 days ago
    Hi @Nagulan Santhi,

    unfortunately, presently it's not possible to change a text field into a ​timestamp, date or other numeric datatypes.

    so you have to unload the table into a text file with copy command, then create a new table with the right datatypes and load with the copy command.