Hive show columns in HDP3

[#1]

In HDP3 show columns function in hive returns the column list in alphabetical order.How to get the columns list in the actual order as in the create table of hive.

[#2]

You should be using the sys.columns catalog view. syscolumns is included only for backwards compatibility. It's really a SQL Server 2000 system table that shouldn't be used in SQL Server 2008 R2. select * from sys.columns where object_id = object_id('MyTable') order by column_id That should return the order of your columns. Note, though, these column id's might not be sequential.

[#3]

@Lewis I m looking for the functionality using show columns in hive table. I m not using SQL server