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
>>> <http://sqoop.apache.org/docs/1.99.3/ClientAPI.html>*
>>>
>>> *thx*
>>> --
>>> [email protected]
>>>
>>
>>
>
>
> --
> 口袋购物|胡齐忠|18001190059|[email protected]
>
> --
> [email protected]|齐忠 <[email protected]>
>
