About divakarreddy_a

divakarreddy_a · ‎07-01-2016

@ed day A fully qualified domain name (FQDN) is the complete domain name for a specific computer, or host, on the Internet. The FQDN consists of two parts: the hostname and the domain name. Ex: hostname.<companyName>.com Give any similar Name and I don't think you will see any issue. Ex: If you hostname is hdp234 then give FQDN like hdp234.abc.com

divakarreddy_a · ‎06-30-2016

@Venkata Chinna Here is the HDP2.4 Supported OS link HDP2.4 OS

divakarreddy_a · ‎06-29-2016

@Antony Shajin Lucas What are you trying to make changes in conf.empty? Hue installation Link: Hue Link as per HDP document make configuration changes in /etc/hue/conf/hue.ini as re-start hue service Command to re-start: service hue restart or service hue stop/start Ideally you will see like below the hue.ini and folder permissions, and directory location. here is the location for logs: /var/log/hue/error.log /var/log/hue/runcpserver.log /var/log/hue/error.log i hope this will help you.

divakarreddy_a · ‎06-27-2016

@Ethan Hsieh I think 2.3.1 is latest version gsonlink

divakarreddy_a · ‎06-22-2016

Thanks Predrag. it's working for "append" and INT column as "check-column" another quick question: Do we need to pass "--last -value" every time based on previous "Upper bound value:####"?

divakarreddy_a · ‎06-22-2016

below script is running fine, then no issues with timestamp running scripts in Teradata, it seems issue with incremental or Upper value milliseconds format. sqoop import \ --connect jdbc:teradata://abc/DATABASE=hadoop,CHARSET=UTF8 \ --driver "com.teradata.jdbc.TeraDriver" \ --username hadoop \ --password 00000 \ --query "select * from text where dw_load_ts >='2016-01-01 00:00:00' AND \$CONDITIONS" \ --target-dir /diva/text \ --m 1

divakarreddy_a · ‎06-22-2016

Changed incremental to lastmodified "--incremental lastmodified" in sqoop script but still getting an error. 16/06/22 04:35:16 ERROR manager.SqlManager: SQL exception accessing current timestamp: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3706] [SQLState 42000] Syntax error: expected something between '(' and ')'. java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3706] [SQLState 42000] Syntax error: expected something between '(' and ')'. ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Could not get current time from database

divakarreddy_a · ‎06-22-2016

I'm thinking that the value of '0000-00-00 00:00:00' date is stored in our db but can't be handled by the driver.

divakarreddy_a · ‎06-22-2016

Hi, I'm trying to run sqoop incremental imports from Teradata to HDFS but running into issues with time stamp. my sqoop command: sqoop import \ --connect jdbc:teradata://PH/DATABASE=hadoop,CHARSET=UTF8 \ --driver "com.teradata.jdbc.TeraDriver" \ --username hadoop \ --password Hadoop \ --table item \ --target-dir /diva/item_text \ --m 1 \ --fields-terminated-by '|' \ --incremental append -check-column dw_modify_ts --last-value '2013-01-01 02:00:00' Error Message: Error: java.io.IOException: SQLException in nextKeyValue Caused by: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 6760] [SQLState HY000] Invalid timestamp. Log Message: ----------------------------------- 16/06/22 04:13:43 INFO tool.ImportTool: Incremental import based on column dw_modify_ts 16/06/22 04:13:43 INFO tool.ImportTool: Lower bound value: '2013-01-01 02:00:00' 16/06/22 04:13:43 INFO tool.ImportTool: Upper bound value: '2013-07-10 22:56:01.0' 16/06/22 04:13:43 INFO mapreduce.ImportJobBase: Beginning import of e2_item_category_text Here as per above log sqoop giving milliseconds as well in Upper bound Value "'2013-07-10 22:56:01.0'? I'm suspecting that this milliseconds format having an issue while importing data from Teradata. Can you suggest me if you have any idea?

divakarreddy_a · ‎06-21-2016

It seems permission issue and user is not able to write the tmp files in /tmp/hive/ Grant write permissions for user and try again.

Online	Offline
Last Visited	‎08-15-2019 08:33 PM

Member Since	‎01-25-2016 03:49 AM
Last Visited	‎08-15-2019 08:33 PM
Posts	345
Kudos received	86

Cloudera Community

Re: best Compression technique?

Re: RStudio to HDP Cluster 2.4

Re: Upgrade ambari 2.4.1 to 2.4.2.0

Re: hive privileges on table vs database.

Re: Upgrade or patch?

Re: FQDNs - are they necessary?

Re: Can I install HDP 2.4 on Ubuntu 16.04 (Single ...

Re: changes made to hue.ini is not read by hue ser...

Re: Hive Hook Error: NoClassDefFoundError: com/goo...

Re: sqoop incremental load failed with timestamp

Re: sqoop incremental load failed with timestamp

Re: sqoop incremental load failed with timestamp

Re: sqoop incremental load failed with timestamp

sqoop incremental load failed with timestamp

Re: java.io.IOException: Previous writer likely fa...