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]
