oleg ruchovets 2012-05-02, 21:46
-RE: dynamic schema (table) creation
David Robson 2012-05-03, 00:08
The Quest Data Connector for Oracle and Hadoop can create the table if you have a template table to work from - and has many other useful features and performance improvements over the default connector. It is free and open source - you can download it from here:
The source code is available from here:
This doesn't achieve exactly what you are after but may help if you knew of another table that would be the same structure. Look in the user guide on page 22 under "Create Oracle Tables" section.
From: oleg ruchovets [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 3 May 2012 7:47 AM
To: [EMAIL PROTECTED]
Subject: dynamic schema (table) creation
Hi , I successfully write my data from hdfs to oracle using Sqoop ( I use java Sqoop.runTool()).
As I understand sqoop examines schema and generate java class. It works fine if I have already created table , but in my case I have no predefined schema. I know table schema only in runtime.
My question is how can I create oracle table using sqoop ?
Thanks in advance