Omnisci SQL and pymapd

Follow

Dipanwita Mallick

• June 16, 2020 22:30

Hi,

I am trying to check the data types of the columns in the omniscidb table using SQL. I am using pymapd to run queries.

would be nice if anyone can give me the command to check the dtypes.

Thanks Dipanwita.

0

• 

  anon45925161

  • June 16, 2020 22:32

  Hi @dipanwita2019,

  You can run the SQL command show create table my_table; to get the DDL for my_table. This should give you the column names and their data types, as well as any additional table options.

  0

  Comment actions Permalink

Please sign in to leave a comment.