I am trying to import data from mysql to hdfs. While importing, I need all the string fields to have double quotes and non-string fields with no double quotes. sqoop import \ --connect jdbc:mysql://<hostname>:3306/retail_db \ --username <user> \ --password <password> \ --target-dir /user/nikhilvemula/sqoop_import/retail_db/orders_test \ --num-mappers 1 \ --query "SELECT * FROM orders WHERE \$CONDITIONS and order_date LIKE '2014-01-%'" \ --enclosed-by '"' \ --null-string '\\N' \ --null-non-string '\\N' \ --delete-target-dir Expected: 25876,2014-01-01 00:00:00.0,3414,"PENDING_PAYMENT" Actual result I got: "25876","2014-01-01 00:00:00.0","3414","PENDING_PAYMENT" ... View more

SELECT COUNT(DISTINCT cust_n) OVER(PARTITION BY ord_id,ord_d) cusp_cnt FROM table1;   -- Not working in Impala. Is there any way to overcome the issue. ... View more

I have a table with 10years of records. I have to import the table with 1year(01-Jan-2010 to 31-Dec-2010) records every time. How to pass these date ranges as arguments to the sqoop shell script. ... View more

What is the underlying filesystem/storage type of Dynamo DB ... View more

Can anyone help in solving the following error I am trying to import data from mysql to hive help-1.pdf ... View more

I have installed hortnworks sandbox on virtual machine. I am unable to perform any Hadoop commands. ... View more

I am planning to take the HDPCA certification exam. I wanted to know what is the pattern of exam? No of questions on each topic, What is the pass % Any tips are appreciated. ... View more

I am creating my first application using Scala IDE. I got some errors. I need to import the jars related to spark. can anyone suggest the jars ... View more