DRock
New Contributor II

The Trace log info is below.  Also, I find it interesting that the log is making reference to hive_metastore (see below), which is not the catalog explicitly stated via the Server Side Properties. 

 

 

 

MSACCESS 3818-164c ENTER SQLAllocEnv

HENV * 0x000000EE247C49A8

 

MSACCESS 3818-164c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)

HENV * 0x000000EE247C49A8 ( 0x0000026296DF7BB0)

 

MSACCESS 3818-164c ENTER SQLAllocConnect

HENV 0x0000026296DF7BB0

HDBC * 0x000000EE247C4A68

 

MSACCESS 3818-164c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)

HENV 0x0000026296DF7BB0

HDBC * 0x000000EE247C4A68 ( 0x000002628CCDF010)

 

MSACCESS 3818-164c ENTER SQLSetConnectOptionW

HDBC 0x000002628CCDF010

SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>

SQLPOINTER 20

 

MSACCESS 3818-164c EXIT SQLSetConnectOptionW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>

SQLPOINTER 20

 

MSACCESS 3818-164c ENTER SQLSetConnectAttrW

SQLHDBC 0x000002628CCDF010

SQLINTEGER 30002 <unknown>

SQLPOINTER [Unknown attribute 30002]

SQLINTEGER -3

 

MSACCESS 3818-164c EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)

SQLHDBC 0x000002628CCDF010

SQLINTEGER 30002 <unknown>

SQLPOINTER [Unknown attribute 30002]

SQLINTEGER -3

 

MSACCESS 3818-164c ENTER SQLDriverConnectW

HDBC 0x000002628CCDF010

HWND 0x0000000000091ABC

WCHAR * 0x00007FFA70F830D8 [ -3] "******\ 0"

SWORD -3

WCHAR * 0x00007FFA70F830D8

SWORD -3

SWORD * 0x0000000000000000

UWORD 1 <SQL_DRIVER_COMPLETE>

 

MSACCESS 3818-164c EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)

HDBC 0x000002628CCDF010

HWND 0x0000000000091ABC

WCHAR * 0x00007FFA70F830D8 [ -3] "******\ 0"

SWORD -3

WCHAR * 0x00007FFA70F830D8 <Invalid buffer length!> [-3]

SWORD -3

SWORD * 0x0000000000000000

UWORD 1 <SQL_DRIVER_COMPLETE>

 

DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 9 <SQL_ODBC_API_CONFORMANCE>

PTR 0x000000EE247C4A70

SWORD 2

SWORD * 0x000000EE247C4A60

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 9 <SQL_ODBC_API_CONFORMANCE>

PTR 0x000000EE247C4A70 (2) <SQL_OAC_LEVEL2>

SWORD 2

SWORD * 0x000000EE247C4A60 (2)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 6 <SQL_DRIVER_NAME>

PTR 0x000000EE247C4AB0

SWORD 200

SWORD * 0x000000EE247C4A60

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 6 <SQL_DRIVER_NAME>

PTR 0x000000EE247C4AB0 [ 46] "Simba Spark ODBC Driver"

SWORD 200

SWORD * 0x000000EE247C4A60 (46)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 46 <SQL_TXN_CAPABLE>

PTR 0x000000EE247C4578

SWORD 2

SWORD * 0x000000EE247C4520

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 46 <SQL_TXN_CAPABLE>

PTR 0x000000EE247C4578 (0) <SQL_TC_NONE>

SWORD 2

SWORD * 0x000000EE247C4520 (2)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 1 <SQL_ACTIVE_STATEMENTS>

PTR 0x000000EE247C4570

SWORD 2

SWORD * 0x000000EE247C4598

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 1 <SQL_ACTIVE_STATEMENTS>

PTR 0x000000EE247C4570 (0)

SWORD 2

SWORD * 0x000000EE247C4598 (2)

 

MSACCESS 3818-164c ENTER SQLAllocStmt

HDBC 0x000002628CCDF010

HSTMT * 0x000000EE247C44F0

 

MSACCESS 3818-164c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

HSTMT * 0x000000EE247C44F0 ( 0x0000026296DEA870)

 

MSACCESS 3818-164c ENTER SQLGetStmtAttrW

SQLHSTMT 0x0000026296DEA870

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 0x000000EE247C4440

SQLINTEGER -5

SQLINTEGER * 0x0000000000000000

 

MSACCESS 3818-164c EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)

SQLHSTMT 0x0000026296DEA870

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 0x000000EE247C4440 (0)

SQLINTEGER -5

SQLINTEGER * 0x0000000000000000

 

MSACCESS 3818-164c ENTER SQLSetStmtAttrW

SQLHSTMT 0x0000026296DEA870

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 60

SQLINTEGER -5

 

MSACCESS 3818-164c EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)

SQLHSTMT 0x0000026296DEA870

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 60

SQLINTEGER -5

 

MSACCESS 3818-164c ENTER SQLExecDirectW

HSTMT 0x0000026296DEA870

WCHAR * 0x00007FFA28681DF0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"

SDWORD -3

 

MSACCESS 3818-164c EXIT SQLExecDirectW with return code -1 (SQL_ERROR)

HSTMT 0x0000026296DEA870

WCHAR * 0x00007FFA28681DF0 [ -3] "SELECT Config, nValue FROM MSysConf\ 0"

SDWORD -3

 

DIAG [S0002] [Simba][SQLEngine] (31740) Table or view not found: hive_metastore..MSysConf (31740)

 

MSACCESS 3818-164c ENTER SQLErrorW

HENV 0x0000026296DF7BB0

HDBC 0x000002628CCDF010

HSTMT 0x0000026296DEA870

WCHAR * 0x000000EE247C4378

SDWORD * 0x000000EE247C4354

WCHAR * 0x0000026293375E50

SWORD 4095

SWORD * 0x000000EE247C4350

 

MSACCESS 3818-164c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)

HENV 0x0000026296DF7BB0

HDBC 0x000002628CCDF010

HSTMT 0x0000026296DEA870

WCHAR * 0x000000EE247C4378 [ 5] "S0002"

SDWORD * 0x000000EE247C4354 (31740)

WCHAR * 0x0000026293375E50 [ 76] "[Simba][SQLEngine] (31740) Table or view not found: hive_metastore..MSysConf"

SWORD 4095

SWORD * 0x000000EE247C4350 (76)

 

MSACCESS 3818-164c ENTER SQLErrorW

HENV 0x0000026296DF7BB0

HDBC 0x000002628CCDF010

HSTMT 0x0000026296DEA870

WCHAR * 0x000000EE247C4378

SDWORD * 0x000000EE247C4354

WCHAR * 0x0000026293375F02

SWORD 4006

SWORD * 0x000000EE247C4350

 

MSACCESS 3818-164c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)

HENV 0x0000026296DF7BB0

HDBC 0x000002628CCDF010

HSTMT 0x0000026296DEA870

WCHAR * 0x000000EE247C4378

SDWORD * 0x000000EE247C4354

WCHAR * 0x0000026293375F02

SWORD 4006

SWORD * 0x000000EE247C4350

 

MSACCESS 3818-164c ENTER SQLFreeStmt

HSTMT 0x0000026296DEA870

UWORD 1 <SQL_DROP>

 

MSACCESS 3818-164c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)

HSTMT 0x0000026296DEA870

UWORD 1 <SQL_DROP>

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 17 <SQL_DBMS_NAME>

PTR 0x000000EE247C4E10

SWORD 200

SWORD * 0x000000EE247C4E00

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 17 <SQL_DBMS_NAME>

PTR 0x000000EE247C4E10 [ 18] "Spark SQL"

SWORD 200

SWORD * 0x000000EE247C4E00 (18)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 0 <SQL_ACTIVE_CONNECTIONS>

PTR 0x000000EE247C4F64

SWORD 2

SWORD * 0x000000EE247C4F60

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 0 <SQL_ACTIVE_CONNECTIONS>

PTR 0x000000EE247C4F64 (0)

SWORD 2

SWORD * 0x000000EE247C4F60 (2)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>

PTR 0x000000EE247C4F78

SWORD 20

SWORD * 0x000000EE247C4F60

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 25 <SQL_DATA_SOURCE_READ_ONLY>

PTR 0x000000EE247C4F78 [ 2] "N"

SWORD 20

SWORD * 0x000000EE247C4F60 (2)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 46 <SQL_TXN_CAPABLE>

PTR 0x000000EE247C4F68

SWORD 2

SWORD * 0x000000EE247C4F10

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 46 <SQL_TXN_CAPABLE>

PTR 0x000000EE247C4F68 (0) <SQL_TC_NONE>

SWORD 2

SWORD * 0x000000EE247C4F10 (2)

 

MSACCESS 3818-164c ENTER SQLGetInfoW

HDBC 0x000002628CCDF010

UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>

PTR 0x000000EE247C4F78

SWORD 20

SWORD * 0x000000EE247C4F60

 

MSACCESS 3818-164c EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>

PTR 0x000000EE247C4F78 [ 2] "`"

SWORD 20

SWORD * 0x000000EE247C4F60 (2)

 

MSACCESS 3818-164c ENTER SQLAllocStmt

HDBC 0x000002628CCDF010

HSTMT * 0x000000EE247C4350

 

MSACCESS 3818-164c EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)

HDBC 0x000002628CCDF010

HSTMT * 0x000000EE247C4350 ( 0x0000026296D13150)

 

MSACCESS 3818-164c ENTER SQLGetStmtAttrW

SQLHSTMT 0x0000026296D13150

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 0x000000EE247C4290

SQLINTEGER -5

SQLINTEGER * 0x0000000000000000

 

MSACCESS 3818-164c EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)

SQLHSTMT 0x0000026296D13150

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 0x000000EE247C4290 (0)

SQLINTEGER -5

SQLINTEGER * 0x0000000000000000

 

MSACCESS 3818-164c ENTER SQLSetStmtAttrW

SQLHSTMT 0x0000026296D13150

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 60

SQLINTEGER -5

 

MSACCESS 3818-164c EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)

SQLHSTMT 0x0000026296D13150

SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT>

SQLPOINTER 60

SQLINTEGER -5

 

MSACCESS 3818-164c ENTER SQLTablesW

HSTMT 0x0000026296D13150

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x00007FFA286FBAF0 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0"

SWORD -3

 

MSACCESS 3818-164c EXIT SQLTablesW with return code 0 (SQL_SUCCESS)

HSTMT 0x0000026296D13150

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x0000000000000000 <null pointer>

SWORD 0

WCHAR * 0x00007FFA286FBAF0 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0"

SWORD -3

 

MSACCESS 3818-164c ENTER SQLNumResultCols

HSTMT 0x0000026296D13150

SWORD * 0x000000EE247C4358

 

MSACCESS 3818-164c EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)

HSTMT 0x0000026296D13150

SWORD * 0x000000EE247C4358 (5)

 

MSACCESS 3818-164c ENTER SQLFetch

HSTMT 0x0000026296D13150

 

MSACCESS 3818-164c EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)

HSTMT 0x0000026296D13150

 

MSACCESS 3818-164c ENTER SQLFreeStmt

HSTMT 0x0000026296D13150

UWORD 0 <SQL_CLOSE>

 

MSACCESS 3818-164c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)

HSTMT 0x0000026296D13150

UWORD 0 <SQL_CLOSE>

 

MSACCESS 3818-164c ENTER SQLFreeStmt

HSTMT 0x0000026296D13150

UWORD 1 <SQL_DROP>

 

MSACCESS 3818-164c EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)

HSTMT 0x0000026296D13150

UWORD 1 <SQL_DROP>