AnsweredAssumed Answered

Drill can't read hive-orc tables

Question asked by Karthee on Jan 22, 2018
Latest reply on Mar 30, 2018 by ajames

Hi, 

 

I am trying to read Hive tables (ORC format) using Hive-2.1 and Drill-1.10.0 with Hive storage plugin.i am able to read Parquet,text format tables. But i can't read the ORC format tables,

 

org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: NumberFormatException: For input string: "0001321_0000"

 

Hive Storage Plugin:

{
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://SAN2LPMR04.node.CO.ZA:9083",
"hive.metastore.warehouse.dir": "/tmp/drill_hive_wh",
"fs.default.name": "maprfs:///",
"hive.metastore.sasl.enabled": "false",
"hive.server2.enable.doAs": "true",
"hive.metastore.execute.setugi": "true"
}
}

 

Do i have to add any parameter in the hive plugin?

 

Please find the attached log.

 

Would really appreciate your assistance in this.

 

 

Thanks,

Karthi

Attachments

Outcomes