[ https://issues.jboss.org/browse/TEIID-2524?page=com.atlassian.jira.plugin... ] Filip Nguyen commented on TEIID-2524: ------------------------------------- Sorry for bad report. The problem are in fact column names. Mixed up in my mind. Below is my DDL and the query that I have to write to select from the INTKEY column. From hive console I can simply write "select intkey from smalla" and it works. {code} CREATE EXTERNAL TABLE smalla(INTKEY INT, STRINGKEY STRING, INTNUM INT, STRINGNUM STRING, FLOATNUM FLOAT, LONGNUM BIGINT, DOUBLENUM DOUBLE, BYTENUM DECIMAL, DATEVALUE TIMESTAMP, TIMEVALUE TIMESTAMP, TIMESTAMPVALUE TIMESTAMP, BOOLEANVALUE BOOLEAN, CHARVALUE STRING, SHORTVALUE SMALLINT, BIGINTEGERVALUE DECIMAL, BIGDECIMALVALUE DECIMAL, OBJECTVALUE BINARY) ROW FORMAT DELIMITED FIELDS TERMINATED BY '44' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/data/bqt/smalla'; {code} {code} ./run.sh QT_Hive_Push "select \"intkey \" from smalla" {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira