Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4950

Kylin create cube error: execute get hive table rows result fail: java.lang.NumberFormatException: For input string:

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • v3.1.1
    • None
    • None
    • hadoop2.7.2
      hive 3.1.2
      hbase 2.0.0
      kylin 3.1.1
    • Important

    Description

      when I build cube ,i keep getting the error in Step Name: Redistribute Flat Hive Table
      Duration

      java.io.IOException: execute get hive table rows result fail : select count(*) from default.kylin_intermediate_cqcyit_cube_16dfe7c6_9e93_8dc6_94f4_b1530f31f2cb
              at         org.apache.kylin.source.hive.CLIHiveClient.getHiveTableRows(CLIHiveClient.java:142)
      	at org.apache.kylin.source.hive.RedistributeFlatHiveTableStep.computeRowCount(RedistributeFlatHiveTableStep.java:38)
      	at org.apache.kylin.source.hive.RedistributeFlatHiveTableStep.doWork(RedistributeFlatHiveTableStep.java:81)
      	at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179)
      	at org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:71)
      	at org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:179)
      	at org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:114)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.NumberFormatException: For input string: "_c0"
      	at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
      	at java.lang.Integer.parseInt(Integer.java:580)
      	at java.lang.Integer.parseInt(Integer.java:615)
      	at org.apache.kylin.source.hive.CLIHiveClient.getHiveTableRows(CLIHiveClient.java:137)
      	... 9 more
      

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            528518960 Mingming Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: