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
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
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
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
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
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,
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
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
