Hive - create a table from a zip file

I have a set of zip files from CSV from which I want to create a Hive table. I am trying to figure out what is the best way to do this.

  • Unzip files, upload them to HDFS.
  • Is there a way to copy files to HDFS, unzip
  • Or is there any other best / recommended way?
+3
source share
1 answer

Common practice is to convert CSV files to split tabs or Ctrl A or Ctrl B, and then upload them to Hadoop / Hive.

To upload files to HDFS, you can use the following command -

hasoop fs -put file_to_uplload hdfs_path

I assume you would like to automate this. In this case, the following instructions will help you.

  • CSV ( ). hive.

  • csv (Ctrl A Ctrl B)

  • Hive.

, / python.

: http://wiki.apache.org/hadoop/Hive/GettingStarted

+2

All Articles