Extract data from partition table
Dheerendra
Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 21 ✭✭✭✭
Hi,
I have partition table have 3 partitions and I need to extract data from table without using partition. When I run the query it giving error like Path does not exist in the dataset: '/process_date=20210629...
Could you please help how I can extract data from partition where next table should be normal table.
Thanks
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 DataikerHi,
You can achieve this using a Sync Recipe in DSS. You can select the Partitions from the input dataset and set the output datasets as not partitioned. When running the recipe the output dataset will contain the desired partions. Below are a few screenshots to illustrate the steps:
