The reason is that I want to insert a search statement with join search results into a table and report an error
Solution:
Execute in hive: set hive.Auto.Convert.Join = false;
Similar Posts:
- How to Delete using INNER JOIN with SQL Server?
- [Solved] Hive Update and Delete Error: Attempt to do update or delete using transaction manager
- [Hive on Tez] Input path does not exists error
- [Solved] Oracle :value too large for column “SCHEMA”.”TABLE”.”COLUMN” (actual: 519, maximum: 500)
- SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”
- Hive Error: Error while compiling statement: FAILED: ParseException line 1:7 Failed to recognize
- Hive SemanticException:Expression not in GROUP BY
- [Solved] spark Connect hive Error: javax.jdo.JDODataStoreException: Required table missing : “`DBS`” in Catalog “” Schema “”
- Hive initialization metadata error [How to Solve]
- [Solved] Greenplum Use the Storage Error: function cannot execute on a QE slice because it accesses relation