CODEWITHSUNDEEP
hivesqoop
user3775193
user3775193

Reputation: 11

how do you import a local csv into hive without creating a schema using sqoop

I have a csv in my local directory and i wish to create a hive table of it..The problem is csv has many columns...

Upvotes: 0

Views: 683

Answers (1)

hadooper
hadooper

Reputation: 746

In authors words Sqoop means Sql-to-Hadoop.. you can't use Sqoop to import data from your local to hdfs in any way.

Sqoop (“SQL-to-Hadoop”) is a straightforward command-line tool with the following capabilities:

  • Imports individual tables or entire databases to files in HDFS
  • Generates Java classes to allow you to interact with your imported data
  • Provides the ability to import from SQL databases straight into your Hive data warehouse


For more information follow below links:
http://blog.cloudera.com/blog/2009/06/introducing-sqoop/
http://kickstarthadoop.blogspot.com/2011/06/how-to-speed-up-your-hive-queries-in.html

Upvotes: 1

Related Questions