Execute hive SQL statement“ The error of “select out from XXX” is as follows:
Error: Error while compiling statement: FAILED: ParseException line 1:7 Failed to recognize predicate ‘out’. Failed rule: ‘identifier’ in table or column identifier (state=42000,code=40000)
My intention is to take out the value of the out field in my table. The bug in this sentence means that out is a reserved word. Although a column in my table is also called out, it can’t directly execute the select out field. It is modified as follows:
select ` out` from XXX
That is to say, put counter quotation marks on both sides of out to solve the problem~
Similar Posts:
- Treatment of MySQL database keyword as column name by mybatisplus — sqlsyntax errorexception: you have an error in your SQL syntax;
- SQL Error: 1064, SQLState: 42000 [Three Methods to Solve]
- pymysql.err.OperationalError: (1054, “Unknown column’aa’in’field list’)
- In Oracle, an error is reported: ora-00904
- SQL Error: 1064, SQLState: 42000ERROR
- [Solved] MYSQL Error: You can’t specify target table for update in FROM clause
- Hive SemanticException:Expression not in GROUP BY
- [Solved] The length of the data truncation done by springboothinesdata for the column.
- [Solved] SQL Error (3621): String or binary data would be truncated The statement has been terminated.
- About BeanShell error invoking BSH method