sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From centerqi hu <cente...@gmail.com>
Subject Both table name and SQL cannot be specified
Date Mon, 30 Dec 2013 11:06:36 GMT
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*
-- 
centerqi@gmail.com

Mime
View raw message