dbWriteTable failed with Error in .combine_results(res_list) :

[willshen99]

I'm writing an in-memory table to hive catalog

DBI::dbWriteTable(con, "iris", iris)

It failed with error message:

Error in .combine_results(res_list) : 
  Chunk column names are different across chunks: []

It's same error message as #254. I also get the same error message with dbRemoveTable.

[willshen99]

The actual failure happened at dbCreateTable. It's same as described in table deletion issue #254 (comment). res_list is an empty list.

For dbWriteTable, adding use.one.query = T makes dbWriteTable to use dbCreateTableAs, thus bypassing this issue

[jarodmeng]

I previously had trouble reproducing the error as I didn't have Hive installed and deployed on my machine. I will try to use Hive from docker rather than deploy a Hive server myself. If I can reproduce the error, I will try to fix it.

[willshen99]

I don't think it's specific to Postgres. I have both hive and postgres catalog and they all failed with same error. Guessing it may due to updated Trino version: I'm using Trino 461.

I added a if empty check for dbFetch and seems fix the issue for our use case.
willshen99@5b48323#diff-311de06ae89550475debf15b8583a4baba7e227811e7cbd2865719713bf45051R68

I can submit a PR, if you think the fix makes sense and won't cause issue to other places.

[jarodmeng]

I tested using Trino 467 with a memory catalog and had no problem running dbWriteTable(). Without a reprex, it would be difficult for me to find out what went wrong and commit a fix.

[jarodmeng]

If you can provide a reprex using a Docker image, it will make the troubleshooting much easier.