https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141615#M104212 <P><A rel="user" href="https://community.cloudera.com/users/14753/mahendradahiya.html" nodeid="14753">@Mahendra Dahiya</A></P><P>The sqoop import --query option is intended to process a single statement and there are warnings about using complex queries. </P><P></P><PRE>The facility of using free-form query in the current version of Sqoop is limited to simple queries where there are no ambiguous projections and no OR conditions in the WHERE clause. Use of complex queries such as queries that have sub-queries or joins leading to ambiguous projections can lead to unexpected results.</PRE><P>A few more details are at this URL: </P><P><A href="https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_free_form_query_imports">https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_free_form_query_imports</A></P> Wed, 07 Dec 2016 23:41:04 GMT TerryP 2016-12-07T23:41:04Z https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141614#M104211 <P></P><P>How to execute multiple SQL queries with Sqoop import --query command? Also what is the maximum size of query string?</P> Wed, 07 Dec 2016 20:15:12 GMT https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141614#M104211 mahendra_dahiya 2016-12-07T20:15:12Z https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141615#M104212 <P><A rel="user" href="https://community.cloudera.com/users/14753/mahendradahiya.html" nodeid="14753">@Mahendra Dahiya</A></P><P>The sqoop import --query option is intended to process a single statement and there are warnings about using complex queries. </P><P></P><PRE>The facility of using free-form query in the current version of Sqoop is limited to simple queries where there are no ambiguous projections and no OR conditions in the WHERE clause. Use of complex queries such as queries that have sub-queries or joins leading to ambiguous projections can lead to unexpected results.</PRE><P>A few more details are at this URL: </P><P><A href="https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_free_form_query_imports">https://sqoop.apache.org/docs/1.4.2/SqoopUserGuide.html#_free_form_query_imports</A></P> Wed, 07 Dec 2016 23:41:04 GMT https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141615#M104212 TerryP 2016-12-07T23:41:04Z https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141616#M104213 <P></P><P>Thanks Terry. What is the alternate solution to execute multiple sql query ?</P> Thu, 08 Dec 2016 00:01:48 GMT https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141616#M104213 mahendra_dahiya 2016-12-08T00:01:48Z https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141617#M104214 <P>You are welcome Mahendra. I think you will have to push the complex query to the database and place those results into a different table and then perform the sqoop command on that table. Best of luck.</P> Thu, 08 Dec 2016 00:43:37 GMT https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141617#M104214 TerryP 2016-12-08T00:43:37Z https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141618#M104215 <P>How about create views in source databases.</P> Thu, 08 Dec 2016 15:14:27 GMT https://community.cloudera.com/t5/Support-Questions/How-to-execute-multiple-SQL-queries-with-Sqoop-import-query/m-p/141618#M104215 diablo2 2016-12-08T15:14:27Z