question will "Show column in table_name" keep the column's order as DDL? in Archives of Support Questions (Read Only)

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

guostong — Wed, 18 Jan 2017 04:52:30 GMT

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,

dtraver — Wed, 18 Jan 2017 05:00:39 GMT

Hi Richard,

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

Regards,

@Darwin

guostong — Wed, 18 Jan 2017 05:04:28 GMT

Thank you very much!