FAQ
Hi Laxman,

Let's make sure that you got the right version:

http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_impala_jdbc.html

Thanks,
Alan

On Fri, Sep 5, 2014 at 11:49 AM, Laxman B wrote:

Hi,

I am new to Impala , whenI try to connect Impala using JDBC, I am getting
the following error. Could you please someone through some light on this.

java.sql.SQLException: Could not establish connection to jdbc:hive2://
151.149.131.21:21050/;auth=noSasl: Required field 'serverProtocolVersion'
is unset!
Struct:TOpenSessionResp(status:TStatus(statusCode:SUCCESS_STATUS),
serverProtocolVersion:null,
sessionHandle:TSessionHandle(sessionId:THandleIdentifier(guid:B4 F0 03 6F
C5 E7 45 14 86 34 12 20 7A C6 FA F3, secret:0C BC D7 31 15 90 41 E9 94 6E
BA 53 5B 7A 3A 0C)), configuration:{ALLOW_UNSUPPORTED_FORMATS=0,
MAX_SCAN_RANGE_LENGTH=0, PARQUET_COMPRESSION_CODEC=SNAPPY, V_CPU_CORES=0,
ABORT_ON_ERROR=0, RESERVATION_REQUEST_TIMEOUT=0, NUM_NODES=0,
ABORT_ON_DEFAULT_LIMIT_EXCEEDED=0, DEFAULT_ORDER_BY_LIMIT=-1,
PARQUET_FILE_SIZE=0, DEBUG_ACTION=, REQUEST_POOL=, MEM_LIMIT=0,
NUM_SCANNER_THREADS=0, SYNC_DDL=0, HBASE_CACHE_BLOCKS=0,
DISABLE_OUTERMOST_TOPN=0, DISABLE_CACHED_READS=0, MAX_ERRORS=0,
EXPLAIN_LEVEL=0, BATCH_SIZE=0, DISABLE_CODEGEN=0, HBASE_CACHING=0,
MAX_IO_BUFFERS=0})
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:180)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:104)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at
com.cloudera.example.ClouderaImpalaJdbcExample.main(ClouderaImpalaJdbcExample.java:39)


Thanks,
Laxman.


On Tuesday, January 28, 2014 1:49:20 AM UTC-8, Charles Deng wrote:

Hi, Alen

I have really rebuild thirdparty by the script bin/build_thirdparty.sh,
and then rebuild the impala using the script build_public.sh,

but the error still happens.

i want to know why the error happens? and how to modify the corresponding
codes to resolve it.

thanks very much.
On Tuesday, January 28, 2014 10:27:33 AM UTC+8, Alan wrote:

Hi Charles,

Have you rebuild thirparty and then rebuild impala?


On Sun, Jan 26, 2014 at 5:05 AM, Charles DAng <zhan8...@gmail.com>
wrote:
can anyone else who know the reason help me ? i am in a hurry about
this problem.


On Sun, Jan 26, 2014 at 5:25 PM, Charles Deng <zhan8...@gmail.com>
wrote:
Hello, alen:



i encounter the same problem (position is unset ) in the v1.1_branch
of https://github.com/cloudera/Impala.

i rebuild the thrift in the thirdparty by using the
"bin/build_thirdparty.sh" script, but the problem did not gone.

please tell me how to resolve the problem.

the error log is below:

[impala@compute-21-13 impala]$ beeline -u "jdbc:hive2://
192.168.34.114:21050/;auth=noSasl" -n "" -p "" -d
org.apache.hive.jdbc.HiveDriver
Listening for transport dt_socket at address: 53587
Connecting to jdbc:hive2://192.168.34.114:21050/;auth=noSasl
Connected to: Hive (version 0.10.0)
Driver: Hive (version 0.10.0-cdh4.3.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 0.10.0-cdh4.3.0 by Apache Hive
0: jdbc:hive2://192.168.34.114:21050/> show tables;
org.apache.thrift.protocol.TProtocolException: Required field
'position' is unset! Struct:TColumnDesc(columnName:name,
typeDesc:TTypeDesc(types:[<TTypeEntry primitiveEntry:
TPrimitiveTypeEntry(type:STRING_TYPE)>]), position:0)
at org.apache.hive.service.cli.thrift.TColumnDesc.validate(
TColumnDesc.java:540)
at org.apache.hive.service.cli.thrift.TColumnDesc$
TColumnDescStandardScheme.read(TColumnDesc.java:624)
at org.apache.hive.service.cli.thrift.TColumnDesc$
TColumnDescStandardScheme.read(TColumnDesc.java:573)
at org.apache.hive.service.cli.thrift.TColumnDesc.read(
TColumnDesc.java:484)
at org.apache.hive.service.cli.thrift.TTableSchema$
TTableSchemaStandardScheme.read(TTableSchema.java:359)
at org.apache.hive.service.cli.thrift.TTableSchema$
TTableSchemaStandardScheme.read(TTableSchema.java:338)
at org.apache.hive.service.cli.thrift.TTableSchema.read(
TTableSchema.java:284)
at org.apache.hive.service.cli.thrift.TGetResultSetMetadataResp$
TGetResultSetMetadataRespStandardScheme.read(
TGetResultSetMetadataResp.java:430)
at org.apache.hive.service.cli.thrift.TGetResultSetMetadataResp$
TGetResultSetMetadataRespStandardScheme.read(
TGetResultSetMetadataResp.java:406)
at org.apache.hive.service.cli.thrift.TGetResultSetMetadataResp.read(
TGetResultSetMetadataResp.java:336)
at org.apache.hive.service.cli.thrift.TCLIService$
GetResultSetMetadata_result$GetResultSetMetadata_
resultStandardScheme.read(TCLIService.java:12285)
at org.apache.hive.service.cli.thrift.TCLIService$
GetResultSetMetadata_result$GetResultSetMetadata_
resultStandardScheme.read(TCLIService.java:12270)
at org.apache.hive.service.cli.thrift.TCLIService$
GetResultSetMetadata_result.read(TCLIService.java:12217)
at org.apache.thrift.TServiceClient.receiveBase(
TServiceClient.java:78)
at org.apache.hive.service.cli.thrift.TCLIService$Client.
recv_GetResultSetMetadata(TCLIService.java:470)
at org.apache.hive.service.cli.thrift.TCLIService$Client.
GetResultSetMetadata(TCLIService.java:457)
at org.apache.hive.jdbc.HiveQueryResultSet.retrieveSchema(
HiveQueryResultSet.java:164)
at org.apache.hive.jdbc.HiveQueryResultSet.<init>(
HiveQueryResultSet.java:143)
at org.apache.hive.jdbc.HiveQueryResultSet$Builder.
build(HiveQueryResultSet.java:131)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:208)
at org.apache.hive.beeline.Commands.execute(Commands.java:750)
at org.apache.hive.beeline.Commands.sql(Commands.java:675)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:785)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:652)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(
BeeLine.java:385)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:368)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
Error: Could not create ResultSet: Required field 'position' is unset!
Struct:TColumnDesc(columnName:name, typeDesc:TTypeDesc(types:[<TTypeEntry
primitiveEntry:TPrimitiveTypeEntry(type:STRING_TYPE)>]), position:0)
(state=,code=0)

To unsubscribe from this group and stop receiving emails from it, send
an email to impala-user...@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send
an email to impala-user...@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send
an email to impala-user+unsubscribe@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 20 of 20 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedJul 18, '13 at 9:04a
activeSep 5, '14 at 10:32p
posts20
users9
websitecloudera.com
irc#hadoop

People

Translate

site design / logo © 2022 Grokbase