https://community.cloudera.com/t5/Support-Questions/orcfiledump-command-throwing-the-error/m-p/310670#M224255 <P>Hi,</P><P>I am trying to generate the orcfile but getting the error.</P><P>Please help.</P><P><STRONG>bin/hive --orcfiledump /user/hive/warehouse/hello.db/mylineitem/000000_0</STRONG><BR />Exception in thread "main" java.lang.ClassNotFoundException: org.apache.orc.tools.FileDump<BR />at java.net.URLClassLoader.findClass(URLClassLoader.java:382)<BR />at java.lang.ClassLoader.loadClass(ClassLoader.java:419)<BR />at java.lang.ClassLoader.loadClass(ClassLoader.java:352)<BR />at java.lang.Class.forName0(Native Method)<BR />at java.lang.Class.forName(Class.java:348)<BR />at org.apache.hadoop.util.RunJar.run(RunJar.java:214)<BR />at org.apache.hadoop.util.RunJar.main(RunJar.java:136)</P><P>&nbsp;</P><P>hive&gt; <STRONG>dfs -ls /user/hive/warehouse/hello.db/mylineitem;</STRONG><BR />Found 2 items<BR />-rw-r--r-- 1 i538738 users 94991181 2021-01-30 08:54 /user/hive/warehouse/hello.db/mylineitem/000000_0<BR />-rw-r--r-- 1 i538738 users 48492091 2021-01-30 08:54 /user/hive/warehouse/hello.db/mylineitem/000001_0</P><P>&nbsp;</P><P>hive&gt; <STRONG>show create table mylineitem;</STRONG><BR />OK<BR />CREATE TABLE mylineitem(<BR />l_orderkey bigint COMMENT 'from deserializer',<BR />l_partkey int COMMENT 'from deserializer',<BR />l_suppkey int COMMENT 'from deserializer',<BR />l_linenumber int COMMENT 'from deserializer',<BR />l_quantity decimal COMMENT 'from deserializer',<BR />l_extendedprice decimal COMMENT 'from deserializer',<BR />l_discount decimal COMMENT 'from deserializer',<BR />l_tax decimal COMMENT 'from deserializer',<BR />l_returnflag varchar(1) COMMENT 'from deserializer',<BR />l_linestatus varchar(1) COMMENT 'from deserializer',<BR />l_shipdate date COMMENT 'from deserializer',<BR />l_commitdate date COMMENT 'from deserializer',<BR />l_receiptdate date COMMENT 'from deserializer',<BR />l_shipinstruct varchar(25) COMMENT 'from deserializer',<BR />l_shipmode varchar(10) COMMENT 'from deserializer',<BR />l_comment varchar(44) COMMENT 'from deserializer')<BR />ROW FORMAT DELIMITED<BR />FIELDS TERMINATED BY '|'<BR />STORED AS INPUTFORMAT<BR />'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'<BR />OUTPUTFORMAT<BR />'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'<BR />LOCATION<BR />'file:/user/hive/warehouse/hello.db/mylineitem'</P><P>TBLPROPERTIES (<BR />'totalSize'='143483272',<BR />'numRows'='6001215',<BR />'rawDataSize'='0',<BR />'numFiles'='2',<BR />'numPartitions'='0',<BR />'transient_lastDdlTime'='1611996844')<BR />Time taken: 0.367 seconds, Fetched: 32 row(s)</P> Sat, 30 Jan 2021 14:40:42 GMT anujseeker 2021-01-30T14:40:42Z