It is telling you to change "INT" to "integer"
I orginally had it as integer, but i changed it because i thought i may of had it wrong due to this error. When i use it this way:
String sqlq = "select edinburgh.* from (call weather.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS index integer, year integer, day integer, time integer, ap integer, rainfall double, windspeed double, temp double DELIMITER ',' HEADER) edinburgh";
I receive this error. This is what I have been receiving:
org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "index integer, [*]year[*] integer," at line 1, column 105.
Was expecting: id
Is this telling me that I need a primary key by chance? That column "year" is just "2013" everytime.
Thanks for your help, I appreciate it.
"index", "year", "day", "time" all are reserved words, so either change it to some other name, or put double quotes around it.