Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Hive - get column names

Tags:

hadoop

hive

Is it possible to retrieve column names from a table and load them into another table or a text file in hive? Please let me know if we can do this

like image 814
Vikash Talanki Avatar asked Sep 26 '13 21:09

Vikash Talanki

1 Answers

A bit more succinct version

hive -S -e "SHOW COLUMNS IN database_name.table_name" > column_names.txt
like image 196
Vikrant Goel Avatar answered Oct 08 '22 23:10

Vikrant Goel
Sign in to Comment

Related questions

http://localhost:9870 does not work HADOOP
Hive- how do I "create table as select.." with partitions from original table?
Using encryption with Hadoop
How can I get the MapReduce Jobs source codes generated by the Hive compiler?
How can I add row numbers for rows in PIG or HIVE?
Hadoop - Produce multiple values for a single key
Getting NULL after create external table in Hive using parquet file as storage
Hue File Browser not working
java.lang.ClassNotFoundException: org.apache.hadoop.hbase.protobuf.generated.MasterProtos$MasterService$BlockingInterface
hive-drop-import-delims not removing newline while using HCatalog in Sqoop
Where does Hbase store data?
How HiveContext of spark internally works?
Change column type in hive
curl: (5) Could not resolve proxy: DELETE; Unknown error
Sorting by value in Hadoop from a file
How to stop a particular job while running Hive queries on Hadoop?
Java Hadoop: How can I create mappers that take as input files and give an output which is the number of lines in each file?
Splitting a tuple into multiple tuples in Pig
how to set classpath for a Java program on hadoop file system
How to resolve java.lang.RuntimeException: PipeMapRed.waitOutputThreads(): subprocess failed with code 2?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!