Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.
AnisurRehman
Explorer

Re: how to sqoop with Impala

by Explorer in Support Questions
‎02-18-2017 02:56 AM
‎02-18-2017 02:56 AM
Thanks for advice and infact I am doing this only but I have one usecase where I am suppose to import one table from oracle11g to either Hive/Impala then add one field called DIMdatekey in resulting FACT table.   is it supported to add one column ie  DIMdatekey in Hive's fact table and populate that field from DateDimension which is there in Hive.   Also, I am afraid of use of Hive knowing this fact below and like to use only Impala with Sqoop.   Limitation of Hive:  1--> All the ANSI SQL standard queries are not supported by HIVE QL(Hive query language)  2--> Sub queries are not supported  3--> No support for update and delete operation 4--> doesn’t support ROW level Insert, Update, Delete. But you can generate new tables   from queries or output query results to files.  5--> cannot change the column data type after the table is created   look forward someone to advice me on OLAP usecase with Hive/Impala in tandem with sqoop.   Regards Anis     ... View more

how to create OLAP Cubes on HADOOP data - Impala ...

by Explorer in Support Questions
‎02-04-2017 10:55 AM
‎02-04-2017 10:55 AM
Dear Cloudera Community,   I am looking for advice on how to create  OLAP Cubes on HADOOP data - Impala Database with  Fact and DIMENSIONS tables.   Reference:   https://vision.cloudera.com/building-a-hadoop-data-warehouse-hadoop-101-for-enterprise-data-professionals-dr-ralph-kimball-answers-your-questions/   Question number 10   Regards Anis ... View more
Labels:

how to sqoop with Impala

by Explorer in Support Questions
‎02-03-2017 01:26 AM
‎02-03-2017 01:26 AM
Dear Cloudera Community,   is there any syntax to replace my query below for Impala database instead of Hive? I am intended to ingest table into impala from Oracle.   sqoop import --hive-import --connect "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=192.168.1.3)(port=1521))(connect_data=(service_name=cdb)))" --table EMPLOYEE1 --username system --password XXXX --m 1   Regards Anis ... View more
Labels:

Need clarity on Cloudera's Hadoop Free Edition

by Explorer in Support Questions
‎01-31-2017 06:28 AM
‎01-31-2017 06:28 AM
I am glad to download and use Quickstart VM. Hope cloudera's Hadoop is open source and free to use entire range of products including CM Manager/impala for production use.   I think if required customer may go later for subscription as and when required but no obligation. kindly clarify. My manager told to download hadoop from Apache site but I got same from your site as cloudera has highest committer on Apache Hadoop. Not sure if your express edition is free and can handle multi Terabyte data on 4 node CDH grid.   Regards Anis ... View more

How to bulk upload Impala -Direct table[Oracle] to...

by Explorer in Support Questions
‎01-31-2017 06:18 AM
‎01-31-2017 06:18 AM
Dear Cloudera Community,   I am new to this community and like to know how to do bulk load from Oracle database one time and daily incremental on ImpalaDB with Sqoop or any other tools  without any use of Hive-ignoring HiveDB completely? I assume Impala is complete replacement for Hive in certain situation.   Regards Anis ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎03-24-2017 07:39 AM
Public Statistics
Date Registered ‎01-29-2017 10:54 AM
Last Visited ‎03-24-2017 07:39 AM
Total Messages Posted 6