Join us at the Everyday AI Conference in London, New York & Bengaluru! REGISTER NOW

Partitioning in Oracle SQL Table

pkansal
Level 3
Partitioning in Oracle SQL Table

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
0 Kudos
1 Reply
fchataigner2
Dataiker
Dataiker

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)

0 Kudos

Labels

?
Labels (1)

Setup info

?
A banner prompting to get Dataiku