Support Questions
Find answers, ask questions, and share your expertise

hive insert into table error

hive insert into table error

Explorer

Hello I am inserting into a table from a table in hive with partition

made some others and worked fine but in this case I have this error

any idea what is the problem?

thank you in advance

hive>

insert into table loancdr_orc partition (part_date, part_hora)
select
CDR_ID, CDR_SUB_ID, CDR_TYPE, SPLIT_CDR_REASON, CDR_BATCH_ID, SRC_REC_LINE_NO, SRC_CDR_ID, SRC_CDR_NO, STATUS, RE_RATING_TIMES,
CREATE_DATE, START_DATE, END_DATE, CUST_LOCAL_START_DATE, CUST_LOCAL_END_DATE, STD_EVT_TYPE_ID, EVT_SOURCE_CATEGORY, OBJ_TYPE, OBJ_ID, OWNER_CUST_ID,
DEFAULT_ACCT_ID, PRI_IDENTITY, BILL_CYCLE_ID, SERVICE_CATEGORY, USAGE_SERVICE_TYPE, SESSION_ID, RESULT_CODE, RESULT_REASON, BE_ID, HOT_SEQ,
CP_ID, RECIPIENT_NUMBER, USAGE_MEASURE_ID, ACTUAL_USAGE, RATE_USAGE, SERVICE_UNIT_TYPE, USAGE_MEASURE_ID2, ACTUAL_USAGE2, RATE_USAGE2, SERVICE_UNIT_TYPE2,
DEBIT_AMOUNT, UN_DEBIT_AMOUNT, DEBIT_FROM_PREPAID, DEBIT_FROM_ADVANCE_PREPAID, DEBIT_FROM_POSTPAID, DEBIT_FROM_ADVANCE_POSTPAID, DEBIT_FROM_CREDIT_POSTPAID,
TOTAL_TAX, FREE_UNIT_AMOUNT_OF_TIMES, FREE_UNIT_AMOUNT_OF_DURATION,
FREE_UNIT_AMOUNT_OF_FLUX_, ACCT_ID_1, ACCT_BALANCE_ID_1, BALANCE_TYPE_1, CUR_BALANCE_1, CHG_BALANCE_1, CURRENCY_ID_1, OPER_TYPE_1, ACCT_ID_2, ACCT_BALANCE_ID_2,
BALANCE_TYPE_2, CUR_BALANCE_2, CHG_BALANCE_2, CURRENCY_ID_2, OPER_TYPE_2, ACCT_ID_3, ACCT_BALANCE_ID_3, BALANCE_TYPE_3, CUR_BALANCE_3, CHG_BALANCE_3,
CURRENCY_ID_3, OPER_TYPE_3, ACCT_ID_4, ACCT_BALANCE_ID_4, BALANCE_TYPE_4, CUR_BALANCE_4, CHG_BALANCE_4, CURRENCY_ID_4, OPER_TYPE_4, ACCT_ID_5,
ACCT_BALANCE_ID_5, BALANCE_TYPE_5, CUR_BALANCE_5, CHG_BALANCE_5, CURRENCY_ID_5, OPER_TYPE_5, ACCT_ID_6, ACCT_BALANCE_ID_6, BALANCE_TYPE_6, CUR_BALANCE_6,
CHG_BALANCE_6, CURRENCY_ID_6, OPER_TYPE_6, ACCT_ID_7, ACCT_BALANCE_ID_7, BALANCE_TYPE_7, CUR_BALANCE_7, CHG_BALANCE_7, CURRENCY_ID_7, OPER_TYPE_7,
ACCT_ID_8, ACCT_BALANCE_ID_8, BALANCE_TYPE_8, CUR_BALANCE_8, CHG_BALANCE_8, CURRENCY_ID_8, OPER_TYPE_8, ACCT_ID_9, ACCT_BALANCE_ID_9, BALANCE_TYPE_9,
CUR_BALANCE_9, CHG_BALANCE_9, CURRENCY_ID_9, OPER_TYPE_9, ACCT_ID_10, ACCT_BALANCE_ID_10, BALANCE_TYPE_10, CUR_BALANCE_10, CHG_BALANCE_10, CURRENCY_ID_10,
OPER_TYPE_10, FU_OWN_TYPE_11, FU_OWN_ID_11, FREE_UNIT_ID_11, FREE_UNIT_TYPE_11, CUR_AMOUNT_11, CHG_AMOUNT_11, FU_MEASURE_ID_11, OPER_TYPE_11, FU_OWN_TYPE_12,
FU_OWN_ID_12, FREE_UNIT_ID_12, FREE_UNIT_TYPE_12, CUR_AMOUNT_12, CHG_AMOUNT_12, FU_MEASURE_ID_12, OPER_TYPE_12, FU_OWN_TYPE_13, FU_OWN_ID_13, FREE_UNIT_ID_13,
FREE_UNIT_TYPE_13, CUR_AMOUNT_13, CHG_AMOUNT_13, FU_MEASURE_ID_13, OPER_TYPE_13, FU_OWN_TYPE_14, FU_OWN_ID_14, FREE_UNIT_ID_14, FREE_UNIT_TYPE_14, CUR_AMOUNT_14,
CHG_AMOUNT_14, FU_MEASURE_ID_14, OPER_TYPE_14, FU_OWN_TYPE_15, FU_OWN_ID_15, FREE_UNIT_ID_15, FREE_UNIT_TYPE_15, CUR_AMOUNT_15, CHG_AMOUNT_15, FU_MEASURE_ID_15,
OPER_TYPE_15, FU_OWN_TYPE_16, FU_OWN_ID_16, FREE_UNIT_ID_16, FREE_UNIT_TYPE_16, CUR_AMOUNT_16, CHG_AMOUNT_16, FU_MEASURE_ID_16, OPER_TYPE_16, FU_OWN_TYPE_17,
FU_OWN_ID_17, FREE_UNIT_ID_17, FREE_UNIT_TYPE_17, CUR_AMOUNT_17, CHG_AMOUNT_17, FU_MEASURE_ID_17, OPER_TYPE_17, FU_OWN_TYPE_18, FU_OWN_ID_18, FREE_UNIT_ID_18,
FREE_UNIT_TYPE_18, CUR_AMOUNT_18, CHG_AMOUNT_18, FU_MEASURE_ID_18, OPER_TYPE_18, FU_OWN_TYPE_19, FU_OWN_ID_19, FREE_UNIT_ID_19, FREE_UNIT_TYPE_19, CUR_AMOUNT_19,
CHG_AMOUNT_19, FU_MEASURE_ID_19, OPER_TYPE_19, FU_OWN_TYPE_20, FU_OWN_ID_20, FREE_UNIT_ID_20, FREE_UNIT_TYPE_20, CUR_AMOUNT_20, CHG_AMOUNT_20, FU_MEASURE_ID_20,
OPER_TYPE_20, ACCT_ID_21, ACCT_BALANCE_ID_21, BALANCE_TYPE_21, BONUS_AMOUNT_21, CURRENT_BALANCE_21, CURRENCY_ID_21, OPER_TYPE_21, ACCT_ID_22, ACCT_BALANCE_ID_22,
BALANCE_TYPE_22, BONUS_AMOUNT_22, CURRENT_BALANCE_22, CURRENCY_ID_22, OPER_TYPE_22, ACCT_ID_23, ACCT_BALANCE_ID_23, BALANCE_TYPE_23, BONUS_AMOUNT_23,
CURRENT_BALANCE_23, CURRENCY_ID_23, OPER_TYPE_23, ACCT_ID_24, ACCT_BALANCE_ID_24, BALANCE_TYPE_24, BONUS_AMOUNT_24, CURRENT_BALANCE_24, CURRENCY_ID_24, OPER_TYPE_24,
ACCT_ID_25, ACCT_BALANCE_ID_25, BALANCE_TYPE_25, BONUS_AMOUNT_25, CURRENT_BALANCE_25, CURRENCY_ID_25, OPER_TYPE_25, ACCT_ID_26, ACCT_BALANCE_ID_26, BALANCE_TYPE_26,
BONUS_AMOUNT_26, CURRENT_BALANCE_26, CURRENCY_ID_26, OPER_TYPE_26, ACCT_ID_27, ACCT_BALANCE_ID_27, BALANCE_TYPE_27, BONUS_AMOUNT_27, CURRENT_BALANCE_27,
CURRENCY_ID_27, OPER_TYPE_27, ACCT_ID_28, ACCT_BALANCE_ID_28, BALANCE_TYPE_28, BONUS_AMOUNT_28, CURRENT_BALANCE_28, CURRENCY_ID_28, OPER_TYPE_28, ACCT_ID_29,
ACCT_BALANCE_ID_29, BALANCE_TYPE_29, BONUS_AMOUNT_29, CURRENT_BALANCE_29, CURRENCY_ID_29, OPER_TYPE_29, ACCT_ID_30, ACCT_BALANCE_ID_30, BALANCE_TYPE_30,
BONUS_AMOUNT_30, CURRENT_BALANCE_30, CURRENCY_ID_30, OPER_TYPE_30, FU_OWN_TYPE_31, FU_OWN_ID_31, FREE_UNIT_TYPE_31, FREE_UNIT_ID_31, BONUS_AMOUNT_31,
CURRENT_AMOUNT_31, FU_MEASURE_ID_31, OPER_TYPE_31, FU_OWN_TYPE_32, FU_OWN_ID_32, FREE_UNIT_TYPE_32, FREE_UNIT_ID_32, BONUS_AMOUNT_32, CURRENT_AMOUNT_32,
FU_MEASURE_ID_32, OPER_TYPE_32, FU_OWN_TYPE_33, FU_OWN_ID_33, FREE_UNIT_TYPE_33, FREE_UNIT_ID_33, BONUS_AMOUNT_33, CURRENT_AMOUNT_33, FU_MEASURE_ID_33, OPER_TYPE_33,
FU_OWN_TYPE_34, FU_OWN_ID_34, FREE_UNIT_TYPE_34, FREE_UNIT_ID_34, BONUS_AMOUNT_34, CURRENT_AMOUNT_34, FU_MEASURE_ID_34, OPER_TYPE_34, FU_OWN_TYPE_35, FU_OWN_ID_35,
FREE_UNIT_TYPE_35, FREE_UNIT_ID_35, BONUS_AMOUNT_35, CURRENT_AMOUNT_35, FU_MEASURE_ID_35, OPER_TYPE_35, FU_OWN_TYPE_36, FU_OWN_ID_36, FREE_UNIT_TYPE_36,
FREE_UNIT_ID_36, BONUS_AMOUNT_36, CURRENT_AMOUNT_36, FU_MEASURE_ID_36, OPER_TYPE_36, FU_OWN_TYPE_37, FU_OWN_ID_37, FREE_UNIT_TYPE_37, FREE_UNIT_ID_37,
BONUS_AMOUNT_37, CURRENT_AMOUNT_37, FU_MEASURE_ID_37, OPER_TYPE_37, FU_OWN_TYPE_38, FU_OWN_ID_38, FREE_UNIT_TYPE_38, FREE_UNIT_ID_38, BONUS_AMOUNT_38,
CURRENT_AMOUNT_38, FU_MEASURE_ID_38, OPER_TYPE_38, FU_OWN_TYPE_39, FU_OWN_ID_39, FREE_UNIT_TYPE_39, FREE_UNIT_ID_39, BONUS_AMOUNT_39, CURRENT_AMOUNT_39,
FU_MEASURE_ID_39, OPER_TYPE_39, FU_OWN_TYPE_40, FU_OWN_ID_40, FREE_UNIT_TYPE_40, FREE_UNIT_ID_40, BONUS_AMOUNT_40, CURRENT_AMOUNT_40, FU_MEASURE_ID_40, OPER_TYPE_40,
concat_ws('-',substr(start_date,0,4),substr(start_date,5,2),substr(start_date,7,2)) as part_date, cast(substr(start_date,9,2) as int) as part_hora
from LoanCDR_zip;


Query ID = hive_20171123134732_aa015ec4-cccb-483f-a7eb-ca2720dc1bbb
Total jobs = 1
Launching Job 1 out of 1


Status: Running (Executing on YARN cluster with App id application_1511286251333_0266)

--------------------------------------------------------------------------------
VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
--------------------------------------------------------------------------------
Map 1 FAILED 1 0 0 1 4 0
--------------------------------------------------------------------------------
VERTICES: 00/01 [>>--------------------------] 0% ELAPSED TIME: 132.60 s
--------------------------------------------------------------------------------
Status: Failed
Vertex failed, vertexName=Map 1, vertexId=vertex_1511286251333_0266_1_00, diagnostics=[Task failed, taskId=task_1511286251333_0266_1_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Container container_e59_1511286251333_0266_01_000002 finished with diagnostics set to [Container failed, exitCode=255. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000002
Exit code: 255
Stack trace: ExitCodeException exitCode=255:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 255
]], TaskAttempt 1 failed, info=[Container container_e59_1511286251333_0266_01_000003 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000003
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]], TaskAttempt 2 failed, info=[Container container_e59_1511286251333_0266_01_000004 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000004
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]], TaskAttempt 3 failed, info=[Container container_e59_1511286251333_0266_01_000005 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000005
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex vertex_1511286251333_0266_1_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]
DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1511286251333_0266_1_00, diagnostics=[Task failed, taskId=task_1511286251333_0266_1_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Container container_e59_1511286251333_0266_01_000002 finished with diagnostics set to [Container failed, exitCode=255. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000002
Exit code: 255
Stack trace: ExitCodeException exitCode=255:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 255
]], TaskAttempt 1 failed, info=[Container container_e59_1511286251333_0266_01_000003 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000003
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]], TaskAttempt 2 failed, info=[Container container_e59_1511286251333_0266_01_000004 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000004
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]], TaskAttempt 3 failed, info=[Container container_e59_1511286251333_0266_01_000005 finished with diagnostics set to [Container failed, exitCode=1. Exception from container-launch.
Container id: container_e59_1511286251333_0266_01_000005
Exit code: 1
Stack trace: ExitCodeException exitCode=1:
at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
at org.apache.hadoop.util.Shell.run(Shell.java:487)
at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303)
at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)


Container exited with a non-zero exit code 1
]]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:0, Vertex vertex_1511286251333_0266_1_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0
hive>
>

2 REPLIES 2

Re: hive insert into table error

Cloudera Employee

Hello Fernando,

Have you tried to capture those logs using the yarn command line ?

yarn logs -applicationId 'number' <- VERTEX Failed is such a generic issue, just showing that some vertice has encountered issues during its task.

With ORC tables, I've seen issues with their heapsize,

orc.compress.size={to low}

But is hard to know without evidences. You could also go through Resource Manager UI > Application_ID > History > then you can search for the attempt_id / container logs.

Regards,

Re: hive insert into table error

Explorer

Thank you Danilo,

We found the problem, it resides in the column partition election. the query was creating a table with to many partitions, and the default limit in hive is 5000.

We select diferent partition and the query run perfect. that is why it ran whit small amount of data.