Question
Express Scripts.com
US
Last activity: 1 May 2018 9:48 EDT
Hadoop Dataset Save operation to CSV showing no data
When I attempted to write a CSV file to HDFS - choosed Save operation from Test Page , I am only seeing "","","". I am trying to write three properties. For every property, I am seeing blank even though I have data existing in my source DB. Note:-Connection is successful and file placed with this "","","".
Please advise if I am missing anything here?
***Moderator Edit: Vidyaranjan | Updated Categories***
JPMorgan Chase & Company
US
Hi,
It seems to be the mapping for CSV file format incorrect, could you please refer below pdn article
Express Scripts.com
US
Thank you Sudhakar.
I have attempted to run it standalone from the dataset rule -> Actions -> Run -> Save operation
Also created an Activity using DataSet-Execute
Any suggestions on specific loggers to enable to see how the binding is happening and if the values are being passed in the binding before it is sent to hadoop?
Pegasystems Inc.
PL
Hi,
It seems that the clipboard page your are trying to save does not have the properties set, that you have mapped on the hdfs data set ruleform.
Please make sure to:
Hi,
It seems that the clipboard page your are trying to save does not have the properties set, that you have mapped on the hdfs data set ruleform.
Please make sure to:
- review your data set mappings
- review the clipboard page that you use for saving - if it has appropriate properties set
For debugging purposes you can switch to JSON format with automapping which will save all the properties that you have on the clipboard page.
Furthermore, if you will still encounter problems, please share the exact steps you are following to save the records. Are you using a data flow, actions->run or dataset-execute?
Express Scripts.com
US
Mappings looks good. I have created BIX extract with same class and same mappings and I can write to data source destination as Teradata DB. Also I can write data to CSV. But when I create the data set and excute standalone it is sending blank values for some reason. For Jason interestingly I am able to atleast pass the headers but not the data while CSV is just quotes with comma separated.