question Re: Sqoop Import --split-by with sql function in Support Questions

question Re: Sqoop Import --split-by with sql function in Support Questions https://community.cloudera.com/t5/Support-Questions/Sqoop-Import-split-by-with-sql-function/m-p/188937#M151030 Got it <A rel="user" href="https://community.cloudera.com/users/86184/elangovankrishna.html" nodeid="86184">@Krish E</A>! If you change your split-by for boundary-queries, do you still have the same issue? <PRE>--boundary-query "SELECT MIN(cast(order_number as UNSIGNED)), MAX(cast(order_number as UNSIGNED)) FROM archive_orders"</PRE>Not sure if your issue isn't related to the single-quote. <PRE>INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(` <- cast(order_number as UNSIGNED) ->`), MAX(`<-cast(order_number as UNSIGNED)->`) FROM `archive_orders`</PRE>As you using the split-by alongside with the sqoop import-Dorg.apache.sqoop.splitter.allow_text_splitter=true, guess sqoop is taking the whole cast function as a column name, but again, it's just a guess 🙂Hope this helps! Mon, 09 Jul 2018 10:49:49 GMT vmurakami 2018-07-09T10:49:49Z