Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODM Extension in SQLDeveloper is failing while mining from Hive View

chakraa4Aug 27 2014 — edited Aug 28 2014

We have created a view on a table from Hadoop Hive using http://cloudera.com/content/support/en/downloads/connectors/hive/hive-odbc-v2-5-5.html. Effectively, the view is created from a dblink which uses the Hive ODBC connection.

While running ODM(Explore Data) on the view, we see the below error.

Message:

None

Detail:

Error in DATAPROFILE_PROG: ORA-01086: savepoint 'DATAPROFILE_PROG' never established in this session or is invalid ORA-20999: Error in create_sample_table: ORA-20999: Error in internal_create_sample_table: ORA-20999: Error in create_table_from_query: ORA-01010: invalid OCI operation ORA-02063: preceding line from HIVE4PC068162 ORA-06512: at "SYS.DBMS_SQL", line 1321 ORA-06512: at "ODMRSYS.ODMR_INTERNAL_UTIL", line 765 ORA-06512: at "ODMRSYS.ODMR_INTERNAL_UTIL", line 782 ORA-06512: at "ODMRSYS.ODMR_ENGINE", line 1118 ORA-06 ORA-06512: at "ODMRSYS.ODMR_ENGINE_DATA", line 1663

At least let us know the reason of failure so that we can also try to resolve or find workaround.

Comments

David Allan-Oracle
The loading type on a table can insert/update/merge/delete - it's up to you what you do, what happens in a load is dependent on the loading type and the data (if there is no new data, then no new rows will be added). The dimension operator has loading behavior consistent with type 1,2,3 SCDs - in the end it boils down to insert/update/merge also.

Cheers
David
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2014
Added on Aug 27 2014
8 comments
2,855 views