Hey regret for the same, as you can see this is a urgent issue I am stuck
at and in a hurry instead of including cloudera mailing list eventually I
ended up in adding cassandra.
Will take care of it in future and thanks for your mail. :)
On Thu, Dec 25, 2014 at 9:01 PM, Jens Rantil <jens.ran...@tink.se> wrote:
> Hi,
>
> Does this have anything to do with Cassandra? Also, please try to avoid
> cross posting; It makes it hard for
> - future readers to read the full thread.
> - anyone to follow the full thread.
> - anyone to respond. I assume there are few who are enrolled to both
> mailing lists at the same time.
>
> Thank you and merry Christmas,
> Jens
>
>
>
> On Thu, Dec 25, 2014 at 2:24 PM, Vineet Mishra <clearmido...@gmail.com>
> wrote:
>
>> Hi All,
>>
>> I am facing a issue while Sqoop(Sqoop version: 1.4.3-cdh4.7.0) Import, I
>> am having a Java threaded code to import data from multiple databases
>> running at different servers.
>>
>> Currently I am doing a Java Process Execute something like to execute
>> sqoop job,
>>
>> Runtime.getRuntime().exec("/usr/bin/sqoop import --driver
>> com.vertica.jdbc.Driver --connect jdbc:vertica://host:port/db --username
>> user --password pwd --query 'select * from table WHERE $CONDITIONS'
>> --split-by id --target-dir /user/hive/warehouse/data/db.db/table
>> --fields-terminated-by '\t' --hive-drop-import-delims -m 1")
>>
>> I am executing the above command as it is and running into exception
>> saying,
>>
>> WARN tool.BaseSqoopTool: Setting your password on the command-line is
>> insecure. Consider using -P instead.
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Error parsing arguments for
>> import:
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument: *
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument: from
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument: table
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument: WHERE
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument:
>> $CONDITIONS'
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument:
>> --split-by
>> 14/12/25 18:38:29 ERROR tool.BaseSqoopTool: Unrecognized argument: id
>> .
>> .
>> .
>> Although I can easily understand the error and reason of the fact as
>> sqoop is internally splitting the command by space and taking the KV which
>> is splitting the free form query as otherwise its runs fine with the table
>> parameter instead, but if I run the same command directly from the command
>> line it works like a charm.
>>
>> wanted to know is there's something that I am missing while going this
>> way,
>>
>> If no,
>>
>> then why is this issue hitting and what's the work around?
>>
>> Urgent Call!
>>
>> Thanks!
>>
>>
>>
>
