Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> dynamic  schema (table) creation

Copy link to this message
RE: dynamic  schema (table) creation
Hi Oleg,

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
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