Partitioning in Oracle SQL Table
Options
pkansal
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 23 ✭✭✭✭
I am trying to read an Oracle table with partitioning. I have specified a date column as a partition but I am getting the following error:
Failed to read data from table
Failed to read data from table, caused by: SQLException: ORA-12801: error signaled in parallel query server P002 ORA-01861: literal does not match format string , caused by: OracleDatabaseException: ORA-12801: error signaled in parallel query server P002 ORA-01861: literal does not match format string
Tagged:
Answers
-
Hi,
DSS apparently can't use the column type of that date for partitioning. The simplest is to make a view out of the table and use the view instead of the original table in your DSS dataset. Something like
create view xxxxx as select cast(date_col as NVARCHAR(50)), ... from the_table
(or some TO_CHAR(...) with an appropriate format)
