Alteryx data not getting loaded for some rows in Hive

[Lumjing]

Hi I have a data set "Sales date" ( vstring), "Discount date" (vstring) I have both string and date. When I write this data set in Hive am not able to get data for some product ids. for some its coming up. can you please help how to address this all the data should come up in hive not sure why few are coming up and few are not. Please find attached data set.

[danilang]

Hi @Lumjing 

Since this issue is dealing with an external database, we're going to need more details.  

• Share your workflow or a the very least an image of it.
• Are you getting any warnings when running the workflow?
• When you're viewing the Hive data, are you looking at the raw table, a view or stored procedure?

Thanks

Dan