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,370 points
736 views

1 answer to this question.

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
• 69,220 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 3, 2019 in Big Data Hadoop by ravikiran
• 4,620 points
580 views
0 votes
1 answer

Explain to me how to transfer data between Azure tables and Hadoop on Azure

I shall redirect you to a link ...READ MORE

answered Jul 4, 2019 in Big Data Hadoop by ravikiran
• 4,620 points
708 views
0 votes
1 answer

How can I import data from mysql to hive tables with incremental data?

Hi@dharmendra, It is common to perform one-time ingestion ...READ MORE

answered Nov 23, 2020 in Big Data Hadoop by MD
• 95,460 points
1,270 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,390 points
1,715 views
+1 vote
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
• 11,380 points
10,979 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
• 11,380 points
2,497 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,548 views
–1 vote
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,390 points
4,586 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
• 69,220 points
1,361 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
• 69,220 points
581 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP