Support Questions
Find answers, ask questions, and share your expertise

Create table from csv

Create table from csv

Explorer

Hi!!

 

Can I create table in Hive stored in TextFile where the columns are infered automatically from CSV header?

 

Thanks!!

 

Regards.

Miguel.

 

1 REPLY 1
Highlighted

Re: Create table from csv

Master Guru
Apache Hive does not have any such feature.

However, the Kite SDK provided in CDH5 supports auto-inference. Checkout the tutorial at http://kitesdk.org/docs/1.1.0/Using-the-Kite-CLI-to-Create-a-Dataset.html which goes over this exact feature. It has also got some cool type detection built in, so you don't get all strings as you would with a trivial schema detection implementation.