Hive / HCatalog Forum

Hive0.13 (windows) Inner Join fails with NumberFormatException

  • #58219
    Harish Bansal

    I am trying a simple inner join on two tables and it always throws same error
    ERROR ql.Driver ( – FAILED: NumberFormatException For input string: “10.00”
    Id Name
    1 A
    2 B
    3 C
    4 D

    Id Name
    1 X
    2 Y
    3 Z

    Query:Select Table_1.Name, Table_2.Name from Table_1 Inner Join Table_2 on Table_1.Id=Table_2.Id.

    Error thrown is :
    ERROR ql.Driver ( – FAILED: NumberFormatException For input string: “10.00”
    java.lang.NumberFormatException: For input string: “10.00”
    at java.lang.NumberFormatException.forInputString(
    at java.lang.Long.parseLong(
    at java.lang.Long.parseLong(
    at org.apache.hadoop.conf.Configuration.getLong(
    at org.apache.hadoop.hive.conf.HiveConf.getLongVar(
    at org.apache.hadoop.hive.conf.HiveConf.getLongVar(
    at org.apache.hadoop.hive.ql.optimizer.ConvertJoinMapJoin.mapJoinConversionPos(
    at org.apache.hadoop.hive.ql.optimizer.ConvertJoinMapJoin.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.ForwardWalker.walk(
    at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(
    at org.apache.hadoop.hive.ql.parse.TezCompiler.optimizeOperatorPlan(
    at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(
    at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(
    at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(
    at org.apache.hadoop.hive.ql.Driver.compile(
    at org.apache.hadoop.hive.ql.Driver.compile(
    at org.apache.hadoop.hive.ql.Driver.compileInternal(
    at org.apache.hadoop.hive.ql.Driver.runInternal(
    at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(
    at org.apache.hadoop.hive.cli.CliDriver.processLine(
    at org.apache.hadoop.hive.cli.CliDriver.executeDriver(
    at org.apache.hadoop.hive.cli.CliDriver.main(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(

to create new topics or reply. | New User Registration

  • Author
  • #58220
    Harish Bansal

    Further information on this is: Id column in both tables in integer. I actually tried this query on a bigger table, when it failed on actual table, I tried it on sample table and it throws same error NumberFormatException For input string: “10.00″ even when none of the tables have id=10.

    Carter Shanklin

    The traceback looks like a parse time error, not a runtime error. Can you look in your hive-site.xml and see if the string “10” appears somewhere there? Or can you paste your entire hive-site.xml? I suspect there is something in your config confusing Hive.

    Jason Dere

    As Carter mentions, it looks like an issue parsing the Hive configuration. Looking at the stack trace it appears to be for configuration value Is that set to 10.00? If so try setting to a integer value.

    Harish Bansal

    Thanks Carter and Jason, It worked.

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.