[GitHub] [iceberg] pvary commented on issue #2198: Hive: got error while joining iceberg table and hive table

[GitBox <gi...@apache.org>]

pvary commented on issue #2198:
URL: https://github.com/apache/iceberg/issues/2198#issuecomment-771636006


   @dixingxing0: I have tried this in the unit tests where the customers table is an iceberg table and have 3 rows:
   ```
   CREATE TABLE c2 (customer_id bigint, first_name string, last_name string);
   
   select count(1),count(a.customer_id),count(b.customer_id)
   from (select customer_id, concat_ws(first_name, last_name) as str from default.customers where customer_id>0) a
   full outer join (select customer_id, concat_ws(first_name, last_name) as str from default.c2 where customer_id>0) b
   on a.str=b.str 
   where a.str is null or b.str is null;
   ```
   
   The queries were successfully executed on my env (Hive 2.3.7/3.1.2, Iceberg master branch)
   
   To repro the case there are several things that would be really helpful:
   - `SHOW CREATE TABLE` output for both source tables
   - Could you please check if the `empty` file actually in the `hive_table1` directory?
   - Could you provide some test data for the iceberg_table?
   - Could you please try to simplify the query?
   
   Thanks,
   Peter


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org