Hi HarshaVardhan,

FAILED: SemanticException Unrecognized file format in STORED AS clause: ORC.

As you can see, the error was because you are using the unsupportted file format. You can skip the hive-exec-0.11.0.jar.

Please use the correct file format. If you have doubts, you can share the command and file with me.

I would be glad to help you in correcting the syntax.

Hope this hleps.

Thanks.

Hi, I'm trying to run this command on hive:

create external table hvac
(Dates String, Times String, TargetTemp String, ActualTemp String,
System String, SystemAge String, BuildingID String)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS ORC tblproperties("orc.compress"="ZLIB");

But I'm getting error:

FAILED: SemanticException Unrecognized file format in STORED AS clause: ORC