Transfer data between 2 Tables having issues with Date conversion from string to Date datatype.

0 votes

Hi team,

I need an assistance from you guys, Could you please help ?!

I'm doing a simple data transfer between 2 Oracle tables( Both the DB's  are on different servers, not the same DB )

I have a table called A in the 1st Oracle DB and, Table B in DB2.

Table A has a date column with the string datatype and, Table B has the date column with the datatype DATE.

I get the following error msg shown in the screenshot below. I'm not sure if the error msg is due to the incorrect format of the date in the source DB.

Dec 28, 2018 in Big Data Hadoop by slayer
• 29,040 points
9 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

This can be solved making use of the following function in Oracle.

to_date(columnname, 'dd/mm/yyyy')

While trying to fetch data from Oracle instead of default query try using the following query.

select to_date(columnname, 'yyyymmdd') from table.

Please make sure that the format of the date should be exactly the same as that in String format else this will not work.

answered Dec 28, 2018 by Omkar
• 65,820 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Explain to me the method to transfer data between Azure tables and Hadoop on Azure

this article on HiveStorageHandler will let you create ...READ MORE

answered May 2 in Big Data Hadoop by ravikiran
• 1,460 points
14 views
0 votes
1 answer

How to transfer data from Netezza to HDFS using Apache Sqoop?

Remove the --direct option. It gives issue ...READ MORE

answered Apr 23, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
181 views
0 votes
1 answer

How can you transfer data from hive to HDFS ?

Hey, Data in Hive tables reside on HDFS, ...READ MORE

answered 5 days ago in Big Data Hadoop by Gitika
• 7,140 points
8 views
0 votes
1 answer
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 9,030 points
1,643 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 9,030 points
130 views
0 votes
10 answers

hadoop fs -put command?

copy command can be used to copy files ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Sujay
7,966 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
555 views
0 votes
1 answer

How to securely transfer data from rdms to hdfs using sqoop?

Sqoop stores metadata in a repository and ...READ MORE

answered Dec 18, 2018 in Big Data Hadoop by Omkar
• 65,820 points
44 views
0 votes
1 answer

How to upgrade from Hadoop 1.2 to Hadoop 2.2?

Here's the solution that worked for me: <dependency> ...READ MORE

answered Nov 21, 2018 in Big Data Hadoop by Omkar
• 65,820 points
24 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.