Home | About | Sematext search-lucene.com search-hadoop.com
 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