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 >> Re: Both table name and SQL cannot be specified


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