https://community.cloudera.com/t5/Support-Questions/Cannot-query-Hive-table-created-with-OpenCSVSerde-in-Impala/m-p/39576#M12455 <P>Hello,</P><P>&nbsp;</P><P>We are trying to query a table which was created in hive using the&nbsp;<EM>OpenCSVSerde&nbsp;</EM>but we are hitting the below error. As far as we know, this comes default with CDH installation and Impala should support it.</P><P>Any reason why we are not able to query the table?</P><P>&nbsp;</P><P><EM>Query: select * from master_staging.rms_dxc_data_mc_cal_reps limit 5</EM></P><P><EM>ERROR: AnalysisException: Failed to load metadata for table: 'master_staging.rms_dxc_data_mc_cal_reps'</EM></P><P><EM>CAUSED BY: TableLoadingException: Failed to load metadata for table: master_staging.rms_dxc_data_mc_cal_reps</EM></P><P><EM>CAUSED BY: InvalidStorageDescriptorException: Impala does not support tables of this type. REASON: SerDe library 'org.apache.hadoop.hive.serde2.OpenCSVSerde' is not supported.</EM></P> Fri, 16 Sep 2022 10:13:15 GMT rinkusingh 2022-09-16T10:13:15Z