Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

No row inserted after query finished successfully in HIVE

No row inserted after query finished successfully in HIVE

Explorer

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

1 REPLY 1

Re: No row inserted after query finished successfully in HIVE

Guru
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?