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 Threaded View
Sqoop >> mail # user >> Both table name and SQL cannot be specified


Copy link to this message
-
Re: Both table name and SQL cannot be specified
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]
>
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