cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

"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

jneira
New Contributor III

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!

2 REPLIES 2

Aviral-Bhardwaj
Esteemed Contributor III

try to check driver logs in the cluster, it will give exact answer

jneira
New Contributor III

thanks for the suggestion, could tell me more about how to check logs in the cluster?

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.