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

Switch to Plain View
Sqoop >> mail # user >> Both table name and SQL cannot be specified


+
centerqi hu 2013-12-30, 11:06
+
Abraham Elmahrek 2013-12-30, 21:28
Copy link to this message
-
Re: Both table name and SQL cannot be specified
Thank you very much for your help.
When I remove the value entered for "Table name",job creation is a success.

However, I get the following error

Exception has occurred during processing command

Exception: org.apache.sqoop.common.SqoopException Message:CLIENT_0001:Server
has returned exception

See server logs, logs inside without any error message, I do not understand
what this error message means

Schema name:

Table name:

Table SQL statement: select name from theme where  ${CONDITIONS}

Table column names: name

Partition column name:

Nulls in partition column:

Boundary query:
Output configuration
Storage type:

  0 : HDFS

Choose: 0

Output format:

  0 : TEXT_FILE

  1 : SEQUENCE_FILE

Choose: 0

Compression format:

  0 : NONE

  1 : DEFAULT

  2 : DEFLATE

  3 : GZIP

  4 : BZIP2

  5 : LZO

  6 : LZ4

  7 : SNAPPY

Choose: 0

Output directory: /user/rd/tmp/udc/sqoop2/theme_1
Throttling resources
Extractors:

Loaders:

New job was successfully created with validation status FINE  and
persistent id 2
2013/12/31 胡齐忠 <[EMAIL PROTECTED]>

> Thank you very much for your help.
> When I remove the value entered for "Table name",job creation is a
> success.
>
> However, I get the following error
>
> Exception has occurred during processing command
>
> Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0001:Server
> has returned exception
>
> See server logs, logs inside without any error message, I do not
> understand what this error message means
>
>
>
> Schema name:
>
> Table name:
>
> Table SQL statement: select name from theme where  ${CONDITIONS}
>
> Table column names: name
>
> Partition column name:
>
> Nulls in partition column:
>
> Boundary query:
>
>
> Output configuration
>
>
> Storage type:
>
>   0 : HDFS
>
> Choose: 0
>
> Output format:
>
>   0 : TEXT_FILE
>
>   1 : SEQUENCE_FILE
>
> Choose: 0
>
> Compression format:
>
>   0 : NONE
>
>   1 : DEFAULT
>
>   2 : DEFLATE
>
>   3 : GZIP
>
>   4 : BZIP2
>
>   5 : LZO
>
>   6 : LZ4
>
>   7 : SNAPPY
>
> Choose: 0
>
> Output directory: /user/rd/tmp/udc/sqoop2/theme_1
>
>
> Throttling resources
>
>
> Extractors:
>
> Loaders:
>
> New job was successfully created with validation status FINE  and
> persistent id 2
>
>
> 2013/12/31 Abraham Elmahrek <[EMAIL PROTECTED]>
>
>> Hey There,
>>
>> You should be able to remove the value entered for "Table name". if it's
>> an empty string, sqoop will validate your query.
>>
>> -Abe
>>
>>
>> On Mon, Dec 30, 2013 at 3:06 AM, centerqi hu <[EMAIL PROTECTED]> wrote:
>>
>>> hi all
>>>
>>> My sqoop verion is 1.99.3
>>>
>>> I can certainly run the following sql
>>>
>>> "SELECT * FROM theme"
>>>
>>> However,
>>>
>>> When I run Sql "SELECT name from theme WHERE ${CONDITIONS}  " get the
>>> errors:Error message: Both table name and SQL cannot be specified
>>>
>>> Schema name:
>>>
>>> Table name: theme
>>>
>>> Table SQL statement: SELECT name from theme WHERE ${CONDITIONS}
>>>
>>> Table column names: name
>>>
>>> Partition column name:
>>>
>>> Nulls in partition column:
>>>
>>> Boundary query:
>>>
>>>
>>> Output configuration
>>>
>>>
>>> Storage type:
>>>
>>>   0 : HDFS
>>>
>>> Choose: 0
>>>
>>> Output format:
>>>
>>>   0 : TEXT_FILE
>>>
>>>   1 : SEQUENCE_FILE
>>>
>>> Choose: 0
>>>
>>> Compression format:
>>>
>>>   0 : NONE
>>>
>>>   1 : DEFAULT
>>>
>>>   2 : DEFLATE
>>>
>>>   3 : GZIP
>>>
>>>   4 : BZIP2
>>>
>>>   5 : LZO
>>>
>>>   6 : LZ4
>>>
>>>   7 : SNAPPY
>>>
>>> Choose: 0
>>>
>>> Output directory: /user/rd/tmp/udc/sqoop2/theme_1
>>>
>>>
>>> Throttling resources
>>>
>>>
>>> Extractors: 1
>>>
>>> Loaders: 1
>>>
>>>
>>> There are issues with entered data, please revise your input:
>>>
>>> Name: theme
>>>
>>>
>>> Database configuration
>>>
>>> Error message: Both table name and SQL cannot be specified
>>>
>>> This is my reference
>>>
>>> *https://cwiki.apache.org/confluence/display/SQOOP/Sqoop2+Quickstart
>>> <https://cwiki.apache.org/confluence/display/SQOOP/Sqoop2+Quickstart>*
>>>
>>>
>>> *http://sqoop.apache.org/docs/1.99.3/ClientAPI.html
+
centerqi hu 2013-12-31, 01:30
+
Abraham Elmahrek 2013-12-31, 01:36
+
centerqi hu 2013-12-31, 02:30
+
Suhas Satish 2014-04-02, 19:54