DSXchange

Posted: **Wed Feb 15, 2017 3:46 am**

I tried to read orc partitioned files with File Connector Stage in DATASTAGE 11.5 but my test job abort with this error:

IIS-CONN-FICO-00030

Code: Select all

An exception occurred: com.ascential.e2.common.CC_Exception: Failed to initialize the parser: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableTimestampObjectInspector incompatible with org.apache.hadoop.hive.serde2.objectinspector.primitive.HiveVarcharObjectInspector at com.ibm.iis.cc.filesystem.FileSystemLogger.createCCException(FileSystemLogger.java:194) at com.ibm.iis.cc.filesystem.FileSystem.readFile(FileSystem.java:1409) at com.ibm.iis.cc.filesystem.FileSystem.readRecordFiles(FileSystem.java:1289) at com.ibm.iis.cc.filesystem.FileSystem.process(FileSystem.java:759) at com.ibm.is.cc.javastage.connector.CC_JavaAdapter.run(CC_JavaAdapter.java:443)

I searched on the web this error id but I didn't find anything that could help me.

So my question is: File Connector Stage (on DATASTAGE 11.5 ) is able to read orc partitioned files?

Thank you!!!

Posted: **Wed Feb 15, 2017 8:05 am**

Orc files? Ah... some kind of Big Data / Hadoop thing like Hive or Pig or Saruman.

Posted: **Mon Apr 01, 2019 1:14 am**

Hello.

Did you find any solution for this issue?
I read txt file from HDFS using File Connector and have the same problem.
Actually most of times, I just rerun and it works perfectly - without any other action.

Thank you so much.
Joyce

Posted: **Mon Apr 01, 2019 7:48 pm**

Slightly off topic; I've been doing a little work with the Snowflake Connector in version 11.7, and it supports orc partitioning.

So the technology is in there. Joyce has found that (in v11.5 anyway) it doesn't always work first time, but can work later - I'd be taking that information back to your official support provider.

Posted: **Mon Apr 01, 2019 11:51 pm**

ray.wurlod wrote:Slightly off topic; I've been doing a little work with the Snowflake Connector in version 11.7, and it supports orc partitioning.

So the technology is in there. Joyce has found that (in v11.5 anyw ...

Ray,
Your post was truncated.
:/

Could you copy the last part?
Thank you so much.

DSXchange

Is File connector able to read orc partitioned files

Is File connector able to read orc partitioned files

Re: Is File connector able to read orc partitioned files