Extract data from partition table

dhyadav79
Level 2
Extract data from partition table

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

 

0 Kudos
1 Reply
AlexT
Dataiker

Hi,

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: 

 

Screenshot 2021-09-07 at 16.33.22.pngScreenshot 2021-09-07 at 16.36.52.png

 

0 Kudos