Sqoop: What happens if both the --query and --columns parameters are present in the Sqoop command? Will one override the other?

mark_poscablo — Wed, 09 Nov 2016 01:43:49 GMT

Re: Sqoop: What happens if both the --query and --columns parameters are present in the Sqoop command? Will one override the other?

LesterMartin — Fri, 11 Nov 2016 21:25:31 GMT

As with all "interesting" questions like this, the best answer is to try it and see for yourself. My hypothesis was that sqoop would report these directives are incompatible with each other and I was glad to see that was what happened when I gave it a try myself.

[root@sandbox Lab3.1]# sqoop import --connect jdbc:mysql://sandbox/test?user=root --table salaries --columns gender,age --query "select * from salaries s where s.salary > 90000.00 and \$CONDITIONS" --split-by gender -m 2 --target-dir willItWork
16/11/11 08:22:34 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950
Cannot specify --query and --table together.
Try --help for usage instructions.
[root@sandbox Lab3.1]#

question Sqoop: What happens if both the --query and --columns parameters are present in the Sqoop command? Will one override the other? in Archives of Support Questions (Read Only)

Sqoop: What happens if both the --query and --columns parameters are present in the Sqoop command? Will one override the other?

Re: Sqoop: What happens if both the --query and --columns parameters are present in the Sqoop command? Will one override the other?