Sqoop, mail # dev - Re: Both table name and SQL cannot be specified - 2014-04-03, 06:33
 Search Hadoop and all its subprojects:

Switch to Threaded View
Copy link to this message
-
Re: Both table name and SQL cannot be specified
Hi Suhas,

change your query to:

*SELECT MIN(SQOOP_SUBQUERY_ALIAS.name), MAX(SQOOP_SUBQUERY_ALIAS.name) FROM
(select count(name) name from voter where 1 = 1) *SQOOP_SUBQUERY_ALIAS

Subquery returns only one value, so min and max will be same value.

On Thu, Apr 3, 2014 at 1:23 AM, Suhas Satish <[EMAIL PROTECTED]> wrote:

Regards
Vasanth kumar RJ

 
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