Re: Importing Oracle data into Hive

2016-01-31 Thread Ashok Kumar
employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibility.  From: Ashok Kumar [mailto:ashok34...@yahoo.com] Sent: 31 Januar

RE: Importing Oracle data into Hive

2016-01-31 Thread Mich Talebzadeh
recipient to ensure that this email is virus free, therefore neither Peridale Technology Ltd, its subsidiaries nor their employees accept any responsibility. From: Ashok Kumar [mailto:ashok34...@yahoo.com] Sent: 31 January 2016 13:15 To: User Subject: Re: Importing Oracle data into Hive

Re: Importing Oracle data into Hive

2016-01-31 Thread Jörn Franke
Well, you can create an empty Hive table in Orc format and use --hive-override in sqoop Alternatively you can use --hive-import and set hive.default.format I recommend to define the schema properly on the command line, because sqoop detection of formats is based on jdbc (Java) types which is no

Re: Importing Oracle data into Hive

2016-01-31 Thread Ashok Kumar
Thanks, Can sqoop create this table as ORC in Hive? On Sunday, 31 January 2016, 13:13, Ashok Kumar wrote: Thanks. Can sqoop create this table as ORC in Hive? On Sunday, 31 January 2016, 13:11, Nitin Pawar wrote: check sqoop On Sun, Jan 31, 2016 at 6:36 PM, Ashok Kumar wrot

Re: Importing Oracle data into Hive

2016-01-31 Thread Nitin Pawar
check sqoop On Sun, Jan 31, 2016 at 6:36 PM, Ashok Kumar wrote: > Hi, > > What is the easiest method of importing data from an Oracle 11g table to > Hive please? This will be a weekly periodic job. The source table has 20 > million rows. > > I am running Hive 1.2.1 > > regards > > > -- Niti

Importing Oracle data into Hive

2016-01-31 Thread Ashok Kumar
  Hi, What is the easiest method of importing data from an Oracle 11g table to Hive please? This will be a weekly periodic job. The source table has 20 million rows. I am running Hive 1.2.1 regards