The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

Hive / HCatalog Forum

ODBC: Execution Error, return code 1

  • #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

The forum ‘Hive / HCatalog’ is closed to new topics and replies.

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.