Skip to Main Content
Forums

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

Kevin Wan-Oracle
This is definitely not something we've seen in the testing environment.

Can you please raise a SR via Oracle Support and provide the following information?

1. Product version. Version 10.4.1 added multi-processor support for Java database connection in case you were using 10.4.0
2. Oracle database version
3. Is the database installed on a physical server or a VM? What's the machine specification, i.e. CPU and memory size?
4. Is the SSPNA_IN table indexed?
5. What is the logging level? Does it help if you change the logging level to ERROR?
6. Please provide the rulebase project and DDL/DML to create tables and insert sample data.
Phil Whitwell-Oracle
Paul,
I am happy to take a look.
I have been working with a couple of customers to get the best performance for the Batch Processor.
If you want to set up a meeting my email is phil.whitwell@oracle.com

Cheers
Phil
Paul Fowler
This problem appears to have fixed itself.

I suspect a problem with my PC. Drivers, java version, or something. Perhaps I wasn't running the version of Java I thought I was running and after downloading the latest java and cleaning up my PC some, everything was set straight.

The database has not changed (to my knowledge.)


So thank you all who looked into this.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2014
Added on Aug 27 2014
#machine-learning
8 comments
2,885 views