Hello All, I have Oracle 11g database it contain the schema which has tables and there data. What i need is import all this data in to Hive. i searched about this , and what i got is use tSqoopImport. and this video http://www.youtube.com/watch?v=wsmL2_fxuEQ but when i follows the steps given in this video i am not getting what to use for Hive component to import data . can any one tell me how to do this.
thanks Sabrina. Is there any alternate solution for my problem. how i import Relational database that is oracle database into Nosql database that is Hive. Talend has tSpooqImport component but i am not getting how to use this in my scenario. Can you help me on this. Thanks & Regards Snehal
Hello, IMHO, the good solution would be to use Sqoop. You can create an external table into hive which points out a HDFS location. Then, you can use the tSqoopImport in order to import the Oracle table into HDFS (at the location you defined in your hive table creation). Then your data will be available using Hive.