Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
+
centerqi hu 2013-12-31, 01:25
Copy link to this message
-
Re: Both table name and SQL cannot be specified
I found a solution, but one thing does not understand why we must add the
input partition data

"Caused by: Exception: java.lang.Throwable Message:
GENERIC_JDBC_CONNECTOR_0005: No column is found to partition data"

https://issues.apache.org/jira/browse/SQOOP-1242

https://reviews.apache.org/r/15765/diff/
<https://reviews.apache.org/r/15765/diff/>

2013/12/31 centerqi hu <[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 胡齐忠 <[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
[EMAIL PROTECTED]|齐忠
+
Abraham Elmahrek 2013-12-31, 01:36
+
centerqi hu 2013-12-31, 02:30
+
Suhas Satish 2014-04-02, 19:54
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB