Reply
Explorer
Posts: 7
Registered: ‎12-06-2017

No row inserted after query finished successfully in HIVE

Hi,

The insert statement ran successfull the log also fine showing below but the table is not listing the insterted row.

Can anybody help on this?

 

INSERT into tbl_name (
    ref_num,
    tbl_nm,
    tbl_nm_s,
    prty_s,
    src_proc_sq,
    src_t,
    dt_offset,
    src_key,
    merge_hint,
    select_hint,
    session_enable_statement,
    session_disable_statement) values (18,
    'D_C_TYPE',
    'CARD_T_M',
    null ,
    42 ,
    'MASTER' ,
    0 ,
    null,
    null,
    null,
    null,
    null) ;

 

INSERT INTO tbl_name (\n m...y.cnt\=0(Stage-1),user=mano,queue=root.users.mano,state=FINISHED,trackingUrl=http://whf00bsy.com:8088/proxy/application_1518483887756_7245/,appMasterHost=whf00bsy.com,startTime=1520678994954,finishTime=1520679052538,finalStatus=SUCCEEDED,memorySeconds=40399,vcoreSeconds=38,preemptedAMContainers=0,preemptedNonAMContainers=0,preemptedResources=<memory:0\, vCores:0>

Regards,

Mano

Highlighted
Cloudera Employee
Posts: 294
Registered: ‎03-23-2015

Re: No row inserted after query finished successfully in HIVE

What client are you using to run the query?

What did the client's output show? It should have a line like below (I used beeline):

INFO : Table default.test stats: [numFiles=7, numRows=1, totalSize=54, rawDataSize=1]

This can tell how many rows inserted. If you don't see that, can you try to use beeline to run the same query?
Announcements