Hi Guys, can someone please explain how does the below join work in the bottom query. Its from thisl tutorial. I don't get the bit after "concat". thanks ON o.swid = concat('{', u.swid ,'}'); CREATE TABLE webloganalytics as SELECT to_date(o.ts) logdate, o.url, o.ip, o.city, upper(o.state) state, o.country, p.category, CAST(datediff(from_unixtime(unix_timestamp()), from_unixtime(unix_timestamp(u.birth_dt,'dd-MMM-yy')))/365 AS INT) age, u.gender_cd FROM omniture o INNER JOIN products p ON o.url = p.url LEFT OUTER JOIN users u ON o.swid = concat('{', u.swid ,'}'); ... View more

Hello Guys, I am having trouble with my query below. Searched a lot on the internet but nothing helped. Please help me understand where the issue is sqoop import \ --connect jdbc:mysql://10.0.0.24/hive_data \ --username root -P \ --query 'select d.driverid, d.name, SUM(t.hours_logged) as hours from driver d JOIN timesheet t on (d.driverid = t.driverid) group by d.driverid,d.name Where $CONDITIONS' --split-by d.driverid \ --target-dir /home/hadoop/sqoop \ --driver com.mysql.jdbc.Driver The error I get is below SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 17/07/20 01:48:14 INFO manager.SqlManager: Executing SQL statement: select d.driverid, d.name, SUM(t.hours_logged) as hours from driver d JOIN timesheet t on (d.driverid = t.driverid) group by d.driverid,d.name Where (1 = 0) 17/07/20 01:48:14 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Where (1 = 0)' at line 1 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Where (1 = 0)' at line 1 please help ... View more

Hello Guys, I am preparing for the hdpcd certification exam and have few questions. The exam will be on HDP2.4 whereas the version available to download from the hortonworks website is HDP2.6, is there much difference in the 2 version? Same goes for other tools HIVE,PIG,SQOOP, they all older versions on the exam. Can I be learning on the new versions in HP2.6 and still be able to do the exam? Will I have access to Ambari HIVE and Ambari PIG in the exam to run my scripts on? or do I have to rely on terminal? I have done all the tutorials on the hortonworks website for PIG and HIVE, is there any additional work recommended? thanks ... View more