"org.apache.hadoop.hive.ql.metadata.HiveException: at least one column must be specified for the table" non deterministic error in a `insert ... select ... ` clause
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 06:07 AM
Hi, first of all thahks for your work in databricks sql.
Unfortunately i am having a problem running insert-selects statements programatically using the jdbc driver.
They all have the form:
`insert into `mytable` select 1, 'foo', moreLiterals`
The statements fails sometimes and i've not found a clear pattern.
Any help would be really appreciated!
Labels:
- Labels:
-
SQL
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-20-2022 06:23 AM
try to check driver logs in the cluster, it will give exact answer
AviralBhardwaj
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2022 06:47 AM
thanks for the suggestion, could tell me more about how to check logs in the cluster?
