Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - Sqoop hive import- specify hive database


Copy link to this message
-
Re: Sqoop hive import- specify hive database
Nitin kak 2013-01-30, 23:41
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
>>
>
>