Ok,
When table is created as ORC but with no transactional property
INSERT/SELECT works
CREATE TABLE sales3
(
PROD_IDbigint ,
CUST_IDbigint ,
TIME_IDtimestamp,
CHANNEL_ID bigint
I believe updates and deletes have always had this constraint. It's at
least hinted at by:
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-ConfigurationValuestoSetforINSERT,UPDATE,DELETE
On Mon, Mar 7, 2016 at 7:46 PM, Mich Talebzadeh
wrote:
> Hi,
>
> I notice
> Is this something new in Hive 2 as I don't recall having this issue
>before?
No.
> | CREATE TABLE `sales3`( |
> | `prod_id` bigint, |
> | STORED AS INPUTFORMAT
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 befor