SqlServiceException occured when using LoadBuilder#build() with Style.ERROR about tsubakuro HOT 4 CLOSED

Thank you for your information. Now parquet dump file is loaded successfully.

from tsubakuro.

Thank you for reporting. The generated SQL looks good. According to status:err_illegal_operation, the write preserve setup might be missing. Can you check the following?

• Is the transaction (used for load operation) type Long?
• If so, is demo table correctly specified as write preserve? This is necessary declaration for long transaction when writing.

from tsubakuro.

• Is the transaction (used for load operation) type Long?
  • Transaction Type Long is specified as opts for transaction in the Load operation.
• If so, is demo table correctly specified as write preserve? This is necessary declaration for long transaction when writing.
  • This is not clear for me. Can I ask how to specify declaration for write preserve?

We must specifiy that in the CREATE TABLE clause or use GRANT authorization for database user?

from tsubakuro.

Write Preserve is the required for any long transaction that does write operation. At the creation of transaction, write target table names should be passed as write preserve as part of transaction option as below:

        var builder = SqlRequest.TransactionOption.newBuilder();
        builder.setType(SqlRequest.TransactionType.LONG);
        var table = SqlRequest.WritePreserve.newBuilder().setTableName("demo").build();
        builder.addWritePreserves(table);
        var transaction = sqlClient.createTransaction(builder.build()).await();
        ...
        ....

from tsubakuro.