You can translate the question and the replies:

Mapping fail at scheduler

Hi , 1. why scheduler job always extract columns name in upper case (not as column name exist at src mysql) ? 2 .after I make mapping to columns ( as src columns different to desination columns in case) at scheduler job which export data at hive ...error happened "com.denodo.scheduler.core.job.ExtractionJob [] - Error closing exporter Group0#JDBCExporter0 com.denodo.scheduler.api.exporter.ExporterException: Method not supported" , any solution for this issue?
user
26-04-2020 05:56:34 -0400

1 Answer

Hi, Exporting column names as all uppercase is the expected behavior of the Scheduler exporter. If, you would like to get the column names as they are in Virtual DataPort Administration Tool, then you perform the following steps: * In Virtual DataPort Administration Tool, execute the query provided in the Scheduler job. * Go to the "Query Results" tab, and click "Save." * Specify an output file, check Include results and Include header, and click "Ok." Regarding "Method not supported" error, you have asked a similar question here: [fail to export data from jdbc source to hhive](https://community.denodo.com/answers/question/details?questionId=9060g000000TRL3AAO&title=fail+to+export+data+from+jdbc+source+to+hhive), hence you could refer to the response there and feel free to reply directly in that thread if you wish to continue the discussion. Hope this helps!
Denodo Team
28-04-2020 08:17:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here