impala insert into partitioned table code example
Example: impala insert multiple rows
[localhost:21000] > describe val_example;
Query: describe val_example
Query finished, fetching results ...
+
| name | type | comment |
+
| id | int | |
| col_1 | boolean | |
| col_2 | double | |
+
[localhost:21000] > insert into val_example values (1,true,100.0);
Inserted 1 rows in 0.30s
[localhost:21000] > select * from val_example;
+
| id | col_1 | col_2 |
+
| 1 | true | 100 |
+
[localhost:21000] > insert overwrite val_example values (10,false,pow(2,5)), (50,true,10/3);
Inserted 2 rows in 0.16s
[localhost:21000] > select * from val_example;
+
| id | col_1 | col_2 |
+
| 10 | false | 32 |
| 50 | true | 3.333333333333333 |
+