Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

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

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

?

Setup info

?
A banner prompting to get Dataiku