I can see the --hive-import in the CDH4 documentation as well. http://archive.cloudera.com/cdh4/cdh/4/sqoop/SqoopUserGuide.html#_literal_sqoop_import_literal
On Wed, Jan 30, 2013 at 6:33 PM, Nitin kak <[email protected]> wrote: > I am using sqoop 1.4 and Hive 0.9. > > "Also please note that hive import is not supported when is Sqoop used > from Oozie.". Thats strange...because I am using it. > > I was doing it the way you said before but there is a "null" value issue > which comes in between. The thing is while importing to a hive table from a > HDFS directory, the NULL values are taken as null strings(well at least for > the non-numeric columns). This creates an inconsistency as for numeric > columns Hive takes \N as null while for string columns, there is "null" > string. This creates issue while exporting data back from HDFS to RDBMS. > > > On Wed, Jan 30, 2013 at 6:22 PM, Jarek Jarcec Cecho <[email protected]>wrote: > >> Hi Nitin, >> would you mind sharing what Sqoop and Hive version are you using? The >> --hive-table command in form <database>.<table> is the correct and >> supported way. However I barely remember that I faced similar issue in the >> past, updating Hive has solved that for me. >> >> Also please note that hive import is not supported when is Sqoop used >> from Oozie. Recommended workaround is to split the task into two actions - >> in first sqoop action import data into HDFS, in second hive action load >> them into Hive. >> >> Jarcec >> >> On Wed, Jan 30, 2013 at 06:00:01PM -0500, Nitin kak wrote: >> > Hi All, >> > >> > Is there a way to specify the Hive database in the "sqoop-import" >> > command into hive(using --hive-import). Tried --hive-table >> > "<database_name>.<table_name>" does not work. I ran the command using >> Oozie >> > but think wont work otherwise too. >> > >> > Thanks, >> > Nitin >> > >
