hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javier (JIRA)" <>
Subject [jira] [Created] (HIVE-14616) CBO phase fails with NPE when quering a table with array field
Date Wed, 24 Aug 2016 08:03:20 GMT
Javier created HIVE-14616:

             Summary: CBO phase fails with NPE when quering a table with array field
                 Key: HIVE-14616
             Project: Hive
          Issue Type: Bug
          Components: CBO
    Affects Versions: 1.2.1
            Reporter: Javier
            Priority: Minor

A "Error: Error while compiling statement: FAILED: NullPointerException null (state=42000,code=40000)"
message appears when issuing a query involving a table with array. Statistics where gathered

analyze table test.table_with_array compute statistics;
analyze table test.table_with_array compute statistics for columns

We couldn't compute statistics for all columns because we got a "FAILED: UDFArgumentTypeException
Only primitive type arguments are accepted but array<string> is passed."

The hive log shows:

2016-08-24 02:35:29,987 INFO  [HiveServer2-Handler-Pool: Thread-145434]: metastore.HiveMetaStore
( - 485: get_table_statistics_req: db=test table=table_with_array
2016-08-24 02:35:29,988 INFO  [HiveServer2-Handler-Pool: Thread-145434]: HiveMetaStore.audit
( - ugi=user    ip=unknown-ip-addr      cmd=get_table_statistics_req:
db=test table=table_with_array
2016-08-24 02:35:30,002 ERROR [HiveServer2-Handler-Pool: Thread-145434]: ql.Driver (
- FAILED: NullPointerException null
        at org.apache.hadoop.hive.ql.stats.StatsUtils.getColStatistics(
        at org.apache.hadoop.hive.ql.stats.StatsUtils.convertColStats(
        at org.apache.hadoop.hive.ql.stats.StatsUtils.getTableColumnStats(
        at org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(
        at org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(
        at org.apache.hadoop.hive.ql.stats.StatsUtils.collectStatistics(
        at org.apache.hadoop.hive.ql.optimizer.stats.annotation.StatsRulesProcFactory$TableScanStatsRule.process(
        at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(
        at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(
        at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(
        at org.apache.hadoop.hive.ql.lib.PreOrderWalker.walk(
        at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(

Best wishes

This message was sent by Atlassian JIRA

View raw message