Support Questions

Find answers, ask questions, and share your expertise

will "Show column in table_name" keep the column's order as DDL?

avatar
Explorer

when I run the command:

show columns in tablename;

I can see all the columns name, looks like the order is same as ddl, can anybody confirm ?

Thanks,

1 ACCEPTED SOLUTION

avatar
Rising Star

Hi Richard,

I can confirm that the 'show columns' Hive command does display them in the table DDL/describe table order.

Regards,

@Darwin

View solution in original post

2 REPLIES 2

avatar
Rising Star

Hi Richard,

I can confirm that the 'show columns' Hive command does display them in the table DDL/describe table order.

Regards,

@Darwin

avatar
Explorer

Thank you very much!