I can see the --hive-import in the CDH4 documentation as well.
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.
>> 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
>> > but think wont work otherwise too.
>> > Thanks,
>> > Nitin