hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Hive 2 insert error
Date Tue, 08 Mar 2016 00:46:44 GMT
Hi,

I noticed this one in Hive2.

insert into sales3 select * from smallsales;
FAILED: SemanticException [Error 10297]: Attempt to do update or delete on
table sales3 that does not use an AcidOutputFormat or is not bucketed

Is this something new in Hive 2 as I don't recall having this issue before?

Table sales3 has been created as follows:

+---------------------------------------------------------------------+--+
|                           createtab_stmt                            |
+---------------------------------------------------------------------+--+
| CREATE TABLE `sales3`(                                              |
|   `prod_id` bigint,                                                 |
|   `cust_id` bigint,                                                 |
|   `time_id` timestamp,                                              |
|   `channel_id` bigint,                                              |
|   `promo_id` bigint,                                                |
|   `quantity_sold` decimal(10,0),                                    |
|   `amount_sold` decimal(10,0))                                      |
| ROW FORMAT SERDE                                                    |
|   'org.apache.hadoop.hive.ql.io.orc.OrcSerde'                       |
| STORED AS INPUTFORMAT                                               |
|   'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'                 |
| OUTPUTFORMAT                                                        |
|   'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'                |
| LOCATION                                                            |
|   'hdfs://rhes564:9000/user/hive/warehouse/oraclehadoop.db/sales3'  |
| TBLPROPERTIES (                                                     |
|   'orc.compress'='SNAPPY',                                          |
|   'transactional'='true',                                           |
|   'transient_lastDdlTime'='1457396808')                             |
+---------------------------------------------------------------------+--+


Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com

Mime
View raw message