[HIVE-8231] Error when insert into empty table with ACID

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Assignee: Damien Carol
• Reporter: Damien Carol
• Created: 23/Sep/14 10:08
• Updated: 01/Oct/19 22:07
• Resolved: 02/Oct/14 08:26

Description

Steps to show the bug :
1. create table

create table encaissement_1b_64m like encaissement_1b;

2. check table

desc encaissement_1b_64m;
dfs -ls hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m;

everything is ok:

0: jdbc:hive2://nc-h04:10000/casino> desc encaissement_1b_64m;                                                                                                              +------------+------------+----------+--+
|  col_name  | data_type  | comment  |
+------------+------------+----------+--+
| id         | int        |          |
| idmagasin  | int        |          |
| zibzin     | string     |          |
| cheque     | int        |          |
| montant    | double     |          |
| date       | timestamp  |          |
| col_6      | string     |          |
| col_7      | string     |          |
| col_8      | string     |          |
+------------+------------+----------+--+
9 rows selected (0.158 seconds)
0: jdbc:hive2://nc-h04:10000/casino> dfs -ls hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m/;
+-------------+--+
| DFS Output  |
+-------------+--+
+-------------+--+
No rows selected (0.01 seconds)

3. Insert values into the new table

insert into table encaissement_1b_64m VALUES (1, 1, '800000000909000000000000', 1, 12.5, '12/05/2014', '','','');

4. Check

0: jdbc:hive2://nc-h04:10000/casino> select id from encaissement_1b_64m;
+-----+--+
| id  |
+-----+--+
+-----+--+
No rows selected (0.091 seconds)

There are already a pb. I don't see the inserted row.

5. When I'm checking HDFS directory, I see delta_0000421_0000421 folder

0: jdbc:hive2://nc-h04:10000/casino> dfs -ls hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m/;
+-----------------------------------------------------------------------------------------------------------------------------------------------------+--+
|                                                                     DFS Output                                                                      |
+-----------------------------------------------------------------------------------------------------------------------------------------------------+--+
| Found 1 items                                                                                                                                       |
| drwxr-xr-x   - hduser supergroup          0 2014-09-23 12:17 hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m/delta_0000421_0000421  |
+-----------------------------------------------------------------------------------------------------------------------------------------------------+--+
2 rows selected (0.014 seconds)

6. Doing a major compaction solves the bug

0: jdbc:hive2://nc-h04:10000/casino> alter table encaissement_1b_64m compact 'major';
No rows affected (0.046 seconds)
0: jdbc:hive2://nc-h04:10000/casino> dfs -ls hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m/;
+--------------------------------------------------------------------------------------------------------------------------------------------+--+
|                                                                 DFS Output                                                                 |
+--------------------------------------------------------------------------------------------------------------------------------------------+--+
| Found 1 items                                                                                                                              |
| drwxr-xr-x   - hduser supergroup          0 2014-09-23 12:21 hdfs://nc-h04/user/hive/warehouse/casino.db/encaissement_1b_64m/base_0000421  |
+--------------------------------------------------------------------------------------------------------------------------------------------+--+
2 rows selected (0.02 seconds)

Issue Links

• duplicates: HIVE-8290 With DbTxnManager configured, all ORC tables forced to be transactional