Member since
11-04-2018
16
Posts
1
Kudos Received
0
Solutions
02-08-2019
02:58 PM
@Geoffrey Shelton Okot Kindly help me out
... View more
02-08-2019
02:58 PM
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
Labels:
- Labels:
-
Apache Hive
-
Apache Sqoop
11-04-2018
03:21 PM
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
Labels:
- Labels:
-
Apache Impala
10-17-2018
11:38 PM
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
Labels:
- Labels:
-
Apache Sqoop
07-17-2018
08:46 PM
@Rock Zhang Can you explain clearly? How did you fix the issue?
... View more
06-15-2018
08:19 PM
Can anyone help in solving the following error I am trying to import data from mysql to hive help-1.pdf
... View more
Labels:
- Labels:
-
Apache NiFi
04-25-2018
02:09 AM
@Kuldeep Kulkarni If I use the port number 2222 followed by the root@localhost after open the terminal, if i enter the ip addr show command the ip address is different from the root@localhost
... View more
04-24-2018
07:25 PM
I have installed hortnworks sandbox on virtual machine. I am unable to perform any Hadoop commands.
... View more
Labels:
- Labels:
-
Apache Hadoop
04-10-2018
06:54 PM
1 Kudo
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
Labels:
- Labels:
-
Certification
04-09-2018
11:10 PM
I don't find the m3.2xlarge
... View more
04-09-2018
08:40 PM
@Geoffrey Shelton Okot I dont find m3.2xlarge option on my aws instance Hortonworks HDPCDeveloper_2.2 PracticeExam_v7.
... View more
04-09-2018
04:22 PM
unable to find the AMI “Hortonworks HDPCDeveloper" on AWS My region is Ohio
... View more
04-03-2018
09:37 PM
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
Labels:
- Labels:
-
Apache Spark