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] >
