sqoop eval --connect “jdbc:mysql://nn01.itversity.com:3306/retail_export” --username retail_dba --password itversity --query “select o.order_status, quarter(o.order_date), sum(oi.order_item_subtotal) from orders o join order_items oi on o.order_id = oi.order_item_order_id group by o.order_status, quarter(o.order_date)”
this is what I have been trying to run.
this is what I am getting
Warning: /usr/hdp/220.127.116.11-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/06/01 01:40:37 INFO sqoop.Sqoop: Running Sqoop version: 18.104.22.168.5.0.0-1245
18/06/01 01:40:37 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P inst
18/06/01 01:40:37 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
Is something wrong with my query?
Thanks in advance