Home | About | Sematext search-lucene.com search-hadoop.com
 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
Abraham Elmahrek 2013-12-30, 21:28
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]
>