https://community.cloudera.com/t5/Support-Questions/Exporting-a-phoenix-table-into-a-csvfile/m-p/299012#M219459 <P>The Phoenix-Hive storage handler as of v4.14.0 (CDH 5.12) seems buggy.&nbsp; I was able to get the Hive external wrapper table working for simple queries, after tweaking column mapping around upper/lower case gotchas.&nbsp; However, it fails to work when I tried the "<FONT face="courier new,courier,monospace">INSERT OVERWRITE DIRECTORY ... SELECT ..</FONT>." command to export to file:</P><P><FONT face="courier new,courier,monospace"><STRONG>org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=</STRONG><EM>&lt;table name&gt;</EM></FONT></P><P>&nbsp;</P><P>This is a known problem that no one is apparently looking at:</P><P><A href="https://issues.apache.org/jira/browse/PHOENIX-4804" target="_blank">https://issues.apache.org/jira/browse/PHOENIX-4804</A></P><P>&nbsp;</P> Wed, 01 Jul 2020 20:23:55 GMT MilesYao 2020-07-01T20:23:55Z