ODBC: Execution Error, return code 1

to create new topics or reply. | New User Registration

This topic contains 0 replies, has 1 voice, and was last updated by  Vadim Kisselmann 1 year, 8 months ago.

  • Creator
    Topic
  • #44092

    Hi folks,
    i use the ODBC Driver on my mac and installed everything like this:
    http://hortonworks.com/hadoop-tutorial/how-to-install-and-configure-the-hortonworks-odbc-driver-on-mac-os-x/

    Connection works and a statement like “select * from testbase”, too.
    But when i execute statements like this: “select status,count(*) from testbase group by status” i received the following error in odbc.log(see below).
    The query itself works great in the hive interface, but not via ODBC.
    We’re using CDH 4.4, hive server 2.

    less /tmp/odbc.log

    SQLHSTMT 0x166ec90
    SQLCHAR * 0x7c0d86
    | select status,count(*) from apachelog gr |
    | oup by status |
    SQLINTEGER -3 (SQL_NTS)

    Microsoft Query B0093000 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
    SQLHSTMT 0x166ec90
    SQLCHAR * 0x7c0d86
    SQLINTEGER -3 (SQL_NTS)

    Microsoft Query B0093000 ENTER SQLError
    SQLHENV 0x1778620
    SQLHDBC 0x17787e0
    SQLHSTMT 0x166ec90
    SQLCHAR * 0xb0092f08
    SQLINTEGER * 0x4195c50
    SQLCHAR * 0x4195c54
    SQLINTEGER 511
    SQLSMALLINT * 0xb0092f4e

    Microsoft Query B0093000 EXIT SQLError with return code 0 (SQL_SUCCESS)
    SQLHENV 0x1778620
    SQLHDBC 0x17787e0
    SQLHSTMT 0x166ec90
    SQLCHAR * 0xb0092f08
    | S1000 |
    SQLINTEGER * 0x4195c50 (35)
    SQLCHAR * 0x4195c54
    | [Hortonworks][Hardy] (35) Error from Hiv |
    | e: error code: ‘1’ error message: ‘Error |
    | while processing statement: FAILED: Exe |
    | cution Error, return code 1 from org.apa |
    | che.hadoop.hive.ql.exec.MapRedTask’. |
    SQLINTEGER 511
    SQLSMALLINT * 0xb0092f4e (196)

    Microsoft Query B0093000 ENTER SQLFreeStmt
    SQLHSTMT 0x166ec90
    SQLUSMALLINT 1 (SQL_DROP)

    Microsoft Query B0093000 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
    SQLHSTMT 0x166ec90
    SQLUSMALLINT 1 (SQL_DROP)
    (END)

    Cheers,
    Vadim

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

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.