Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21015

HCatLoader can't provide statistics for tables not in default DB

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • None
    • None

    Description

      This is due to a former change (HIVE-20330) that does not take database into consideration when retrieving the proper InputJobInfo for the loader.
      Found during testing:

      07:52:56 2018-12-05 07:52:16,599 [main] WARN  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.InputSizeReducerEstimator - Couldn't get statistics from LoadFunc: org.apache.hive.hcatalog.pig.HCatLoader@492fa72a
      07:52:56 java.io.IOException: java.io.IOException: Could not calculate input size for location (table) tpcds_3000_decimal_parquet.date_dim
      07:52:56 	at org.apache.hive.hcatalog.pig.HCatLoader.getStatistics(HCatLoader.java:281)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.InputSizeReducerEstimator.getInputSizeFromLoader(InputSizeReducerEstimator.java:171)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.InputSizeReducerEstimator.getTotalInputFileSize(InputSizeReducerEstimator.java:118)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.InputSizeReducerEstimator.getTotalInputFileSize(InputSizeReducerEstimator.java:97)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.InputSizeReducerEstimator.estimateNumberOfReducers(InputSizeReducerEstimator.java:80)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.estimateNumberOfReducers(JobControlCompiler.java:1148)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.calculateRuntimeReducers(JobControlCompiler.java:1115)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.adjustNumReducers(JobControlCompiler.java:1063)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.getJob(JobControlCompiler.java:564)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.JobControlCompiler.compile(JobControlCompiler.java:333)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher.launchPig(MapReduceLauncher.java:221)
      07:52:56 	at org.apache.pig.backend.hadoop.executionengine.HExecutionEngine.launchPig(HExecutionEngine.java:293)
      07:52:56 	at org.apache.pig.PigServer.launchPlan(PigServer.java:1475)
      07:52:56 	at org.apache.pig.PigServer.executeCompiledLogicalPlan(PigServer.java:1460)
      07:52:56 	at org.apache.pig.PigServer.storeEx(PigServer.java:1119)
      07:52:56 	at org.apache.pig.PigServer.store(PigServer.java:1082)
      07:52:56 	at org.apache.pig.PigServer.openIterator(PigServer.java:995)
      07:52:56 	at org.apache.pig.tools.grunt.GruntParser.processDump(GruntParser.java:782)
      07:52:56 	at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:383)
      07:52:56 	at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:230)
      07:52:56 	at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:205)
      07:52:56 	at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:81)
      07:52:56 	at org.apache.pig.Main.run(Main.java:630)
      07:52:56 	at org.apache.pig.Main.main(Main.java:175)
      07:52:56 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      07:52:56 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      07:52:56 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      07:52:56 	at java.lang.reflect.Method.invoke(Method.java:498)
      07:52:56 	at org.apache.hadoop.util.RunJar.run(RunJar.java:313)
      07:52:56 	at org.apache.hadoop.util.RunJar.main(RunJar.java:227)
      07:52:56 Caused by: java.io.IOException: Could not calculate input size for location (table) tpcds_3000_decimal_parquet.date_dim
      07:52:56 	at org.apache.hive.hcatalog.pig.HCatLoader.getStatistics(HCatLoader.java:276)
      07:52:56 	... 29 more

      Attachments

        1. HIVE-21015.0.patch
          23 kB
          Ádám Szita
        2. HIVE-21015.1.patch
          23 kB
          Ádám Szita
        3. HIVE-21015.2.patch
          23 kB
          Ádám Szita
        4. HIVE-21015.3.patch
          23 kB
          Ádám Szita

        Activity

          People

            szita Ádám Szita
            szita Ádám Szita
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: