About AnisurRehman

AnisurRehman · ‎02-18-2017

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

AnisurRehman · ‎02-04-2017

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

AnisurRehman · ‎02-03-2017

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

AnisurRehman · ‎01-31-2017

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

AnisurRehman · ‎01-31-2017

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

Online	Offline
Last Visited	‎03-24-2017 07:39 AM

Member Since	‎01-29-2017 10:54 AM
Last Visited	‎03-24-2017 07:39 AM
Posts	6

Cloudera Community

Re: how to sqoop with Impala

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

how to sqoop with Impala

Need clarity on Cloudera's Hadoop Free Edition

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