Reply
New Contributor
Posts: 3
Registered: ‎03-28-2019

Boundary-query not working in cloudera

I am trying to include boundary query in the sqoop script in cloudera. But, i am getting incompatible value. Could you please confirm if boundary-query can be used for sqoop import.

Highlighted
Cloudera Employee
Posts: 39
Registered: ‎01-07-2019

Re: Boundary-query not working in cloudera

In general please try to include as much relevant information as possible, at minimum:

 

1. I am trying to run this exact scoop command

2. It gives me this exact error.

 

----

 

That being said, I suspect that you have an invalid query in your boundary-query.

 

Please start by staying as close to the documentation as possible. Assuming your import works without using the boundary-query, here is what we see in the documentation:

 

--boundary-query select min(<split-by>), max(<split-by>) from <table name>

This could for example translate to:

 

--boundary-query select min(cust_id), max(cust_id) from customer

 

From here, build up towards what you are actually looking for, two more creative (and untested) examples:

 

--boundary-query select min(cust_id), 2*max(cust_id) from customer

--boundary-query select 0, 10000 

Hopefully this helps, otherwise please indicate the step where you got stuck and provide as much relevant context as possible (including the exact command and output!).

 

Announcements