I found a solution to resolve this issue: replace the content of
˜/.sqoop/metastore.db.script with following codes. However, I have a
questions: what code generated ˜/.sqoop/metastore.db.script?
Codes for replacement:
SET DATABASE UNIQUE NAME HSQLDB427399082E
SET DATABASE GC 0
SET DATABASE DEFAULT
I am confusing these exceptions... For using 'sqoop job --list' command,
sqoop will connect to hsqldb, and need hsqldb has a database for storing
sqoop job metadata in advance, right?
2013/11/19 sam liu
> Updated the exception info:
>
>
> Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin
It turns out that hive uses the current directory as the metadata store
location.
Running the sqoop command and hive command from the same location fixed my
problem.
From: "p...@insufficient-light.com"
To: user@sqoop.apache.org
Sent: Tuesday, November 19,
It looks like the answer lies here:
13/11/19 15:02:16 WARN tool.BaseSqoopTool: It seems that you've specified
at least one of following:
13/11/19 15:02:16 WARN tool.BaseSqoopTool: --hive-home
13/11/19 15:02:16 WARN tool.BaseSqoopTool: --hive-overwrite
13/11/19 15:02:16 WARN tool.BaseSqoo
Just started to use Hadoop, Hive, Sqoop today. Sorry for any stupid questions.
I managed to run a sqoop-import command. The command output says "Hive import
complete". But I cannot see the table within hive. Hive command "show tables"
show nothing.
My Sqoop command is:
/bin/sqoop-import --conn
Currently hive import is not supported with Sqoop 1.99.3. Please use
Sqoop 1.4.4 which support hive imports
Thanks
Venkat
On Tue, Nov 19, 2013 at 10:06 AM, Kevin Zhang wrote:
> Hi,
>
> I'm new to Sqoop. Can anybody please tell me how to import mysql database
> table into hive database with S
Hi,
I'm new to Sqoop. Can anybody please tell me how to import mysql database table
into hive database with Sqoop?
I'm using sqoop-1.99.3-bin-hadoop100.tar.gz . I searched but could not find the
answer. Right now I can import mysql database table to hadoop text files. For
1.99.3, I cannot fi
It did not worked with a backslash.
On Monday, November 18, 2013 5:06 PM, "Kallinteris, Christos"
wrote:
Hello Raj,
I’m pretty sure you need a backslash in front of the instance name instead of a
slash
Please try
sqoop import --connect
'jdbc:sqlserver://ABC_SERVER:1433\Instance_Na
