Error when connecting to HiveServer using DataDirect ODBC driver - Forum - DataDirect Connect - Progress Community

Error when connecting to HiveServer using DataDirect ODBC driver

 Forum

Error when connecting to HiveServer using DataDirect ODBC driver

  • I am receiving the following error when trying to connect to Hive:

    Internal error processing clean

    Does anyone know what might be the reason for that?

    Your support is very much appreciated.

    Many Thanks

  • That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

  • To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).

    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:

    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110

    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.

    Many Thanks,

    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.


  • You need to look at the hiveserver log. If it says the clean is not a valid command you can disable it.
    If it is another message, please send it to us.
     
     
    Older versions of Hive 1 required the sending the hive clean command to release locks.
    You can disable this with the connect option SendCleanOnClose=0
     
    However, if the server still required it, lock may not be freed
     
    From: artiintell [mailto:bounce-artiintell@community.progress.com]
    Sent: Wednesday, March 25, 2015 8:24 AM
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by artiintell
    The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).
     
    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:
     
    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Some information regarding Apache Hive error logging can be found in their documentation/wiki: cwiki.apache.org/.../GettingStarted

    Phil

  • Hi,

    I have caught the error log on the server side:

    2015-03-30 15:49:33,414 ERROR thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing clean
    java.lang.NullPointerException
    at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.clean(HiveServer.java:234)
    at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:835)
    at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:820)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
    2015-03-30 15:51:41,150 INFO  exec.HiveHistory 

    Is there anything that can help? I have the full log so if you need more info I am happy to provide it.

    Many Thanks,

    On Wed, Mar 25, 2015 at 12:23 PM, artiintell <bounce-artiintell@community.progress.com> wrote:
    Reply by artiintell
    The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).

    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:

    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110

    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.

    Many Thanks,

    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.


    Stop receiving emails on this subject.

    Flag this post as spam/abuse.


  • Ok this is an issue with the hive server, not the driver  There are no arguments to a clean.
    From: artiintell [mailto:bounce-artiintell@community.progress.com]
    Sent: Monday, March 30, 2015 11:44 AM
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by artiintell
    Hi,
     
    I have caught the error log on the server side:
     
    2015-03-30 15:49:33,414 ERROR thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing clean
    java.lang.NullPointerException
                at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.clean(HiveServer.java:234)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:835)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:820)
                at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
                at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
                at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                at java.lang.Thread.run(Thread.java:744)
    2015-03-30 15:51:41,150 INFO  exec.HiveHistory 
     
    Is there anything that can help? I have the full log so if you need more info I am happy to provide it.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:23 PM, artiintell <bounce-artiintell@community.progress.com> wrote:
    Reply by artiintell
    The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).
     
    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:
     
    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

  • Hi thanks for the suggestion,

    Looking at the logs It appears that the “Clean command” is used to remove PreparedStatement used by Data Nucleus (the ORM layer used by Hive) query to the metastore. Could it be that if the metastore database did not support PreparedStatements, then this condition (error mentioned earlier) wouldn’t be encountered? And otherwise it would? Another question is what the driver was tested against in terms of metastores e.g. was it tested with Oracle as a metastore etc.?

    Thanks,

    On Mon, Mar 30, 2015 at 5:39 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    Ok this is an issue with the hive server, not the driver  There are no arguments to a clean.
    From: artiintell [mailto:bounce-artiintell@community.progress.com]
    Sent: Monday, March 30, 2015 11:44 AM
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by artiintell
    Hi,
     
    I have caught the error log on the server side:
     
    2015-03-30 15:49:33,414 ERROR thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing clean
    java.lang.NullPointerException
                at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.clean(HiveServer.java:234)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:835)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:820)
                at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
                at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
                at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                at java.lang.Thread.run(Thread.java:744)
    2015-03-30 15:51:41,150 INFO  exec.HiveHistory 
     
    Is there anything that can help? I have the full log so if you need more info I am happy to provide it.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:23 PM, artiintell <bounce-artiintell@community.progress.com> wrote:
    Reply by artiintell
    The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).
     
    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:
     
    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.


  • The java.lang.NullPointerException is a BUG in the Hive server. This should not happen.
    Can they test with  a newer version of Hive  to see if Apache fixed the bug?
     
    I do not think we test Oracle as the metastore.  I would have to find out. But again the bug is happening in the Hive Server.
    I think our testing is with mysql.
    From: artiintell [mailto:bounce-artiintell@community.progress.com]
    Sent: Thursday, April 02, 2015 10:07 AM
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by artiintell
    Hi thanks for the suggestion,
     
    Looking at the logs It appears that the “Clean command” is used to remove PreparedStatement used by Data Nucleus (the ORM layer used by Hive) query to the metastore. Could it be that if the metastore database did not support PreparedStatements, then this condition (error mentioned earlier) wouldn’t be encountered? And otherwise it would? Another question is what the driver was tested against in terms of metastores e.g. was it tested with Oracle as a metastore etc.?
     
    Thanks,
     
    On Mon, Mar 30, 2015 at 5:39 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    Ok this is an issue with the hive server, not the driver  There are no arguments to a clean.
    From: artiintell [mailto:bounce-artiintell@community.progress.com]
    Sent: Monday, March 30, 2015 11:44 AM
    To: TU.DD.Connect@community.progress.com
    Subject: Re: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by artiintell
    Hi,
     
    I have caught the error log on the server side:
     
    2015-03-30 15:49:33,414 ERROR thrift.ProcessFunction (ProcessFunction.java:process(41)) - Internal error processing clean
    java.lang.NullPointerException
                at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.clean(HiveServer.java:234)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:835)
                at org.apache.hadoop.hive.service.ThriftHive$Processor$clean.getResult(ThriftHive.java:820)
                at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
                at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
                at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                at java.lang.Thread.run(Thread.java:744)
    2015-03-30 15:51:41,150 INFO  exec.HiveHistory 
     
    Is there anything that can help? I have the full log so if you need more info I am happy to provide it.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:23 PM, artiintell <bounce-artiintell@community.progress.com> wrote:
    Reply by artiintell
    The customer I am working with is running an Apache Hive 0.11 as far as I am aware and they run HiveServer not HiveServer2 (they do not want to run HiveServer2 for some reasons).
     
    I have enabled ODBC trace and managed to get some information which may be helpful and is the following:
     
    ENTER SQLSetEnvAttr
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
                    SQLHENV             0x00000000642110
                    SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
                    SQLPOINTER                 3
                    SQLINTEGER                  -6
     
    ENTER SQLAllocHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8
     
    EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000642110
                    SQLHANDLE *         0x0000000063cdf8 ( 0x00000000644080)
     
    ENTER SQLDriverConnect
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    EXIT  SQLDriverConnect  with return code -1 (SQL_ERROR)
                    HDBC                0x00000000644080
                    HWND                           (nil)
                    UCHAR *             0x007f8ae62b4b84 [4294967293] "******"
                    SWORD                       -3
                    UCHAR *             0x007f8ae62b4b84
                    SWORD                        6
                    SWORD *             0x007ffff3aefcde
                    UWORD                        0 <SQL_DRIVER_NOPROMPT>
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  1
                    SQLCHAR *           0x007ffff3aef450 [  5] "HY000"
                    SQLINTEGER *        0x007ffff3aef458 (6)
                    SQLCHAR *           0x007ffff3aef040 [ 86] "[XXXX][ODBC Apache Hive Wire Protocol driver][Hive]Internal error processing clean"
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c (86)
     
    ENTER SQLGetDiagRec
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    EXIT  SQLGetDiagRec  with return code 100 (SQL_NO_DATA_FOUND)
                    SQLSMALLINT                  2
                    SQLHANDLE           0x00000000644080
                    SQLSMALLINT                  2
                    SQLCHAR *           0x007ffff3aef450 (NYI)
                    SQLINTEGER *        0x007ffff3aef458
                    SQLCHAR *           0x007ffff3aef040 (NYI)
                    SQLSMALLINT               1024
                    SQLSMALLINT *       0x007ffff3aef45c
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  2 <SQL_HANDLE_DBC>
                    SQLHANDLE           0x00000000644080
     
    ENTER SQLFreeHandle
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
                    SQLSMALLINT                  1 <SQL_HANDLE_ENV>
                    SQLHANDLE           0x00000000642110
     
    I will also ask them to enable logging on a server side. It will be very much appreciated if you can point me to what needs to be configured and where to start logging info that can help us to identify the problem.
     
    Many Thanks,
     
    On Wed, Mar 25, 2015 at 12:02 PM, csands <bounce-csands@community.progress.com> wrote:
    Reply by csands
    To get that message, the driver thinks it is  running against a hive 1 server.
    Is this what you intend to do?
     
    If so, can you tell me the vendor and version of the hive server   i.e.    Apache  0.12,    Cloudera    0.12.05
     
    Hive2  is  a more stable, multi user server. You should consider using it.
    Also as of Hive 1.0,  the hive server 1 is no longer supported by Apache.
     
    If it is a hiver 2 server. Change the WireProtocolVersion connect setting  to 2   (hive server 2)
    And see if that fixes your problem.
    From: Phil [mailto:bounce-pprudich@community.progress.com]
    Sent: Tuesday, March 24, 2015 5:07 PM
    To: TU.DD.Connect@community.progress.com
    Subject: RE: [Technical Users - DataDirect Connect] Error when connecting to HiveServer using DataDirect ODBC driver
     
    Reply by Phil

    That error comes from the server itself.  Was there more to the message?  Some versions of the server appear to provide more followup information which may be of use.

    Alternatively, you may need to consult your server log files if you haven't done so already to see if more information may be available there.

    Hope this helps,

    Phil

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.

     
    Stop receiving emails on this subject.

    Flag this post as spam/abuse.