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,050 points
15 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
• 67,120 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
• 3,560 points
26 views
0 votes
1 answer
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,240 points
232 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 May 16 in Big Data Hadoop by Gitika
• 19,720 points
40 views
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
• 10,110 points
2,054 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
• 10,110 points
197 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
10,510 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,240 points
766 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
• 67,120 points
62 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
• 67,120 points
30 views