Member since
07-27-2016
9
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
98965 | 05-23-2017 01:01 AM |
08-14-2017
11:15 PM
Team, A client is facing issue while trying to connect with the Hive... they have hourly, daily and weekly jobs that loading data to HDFS. As per their comment that few of the jobs can connect but mostly failed due to below issue. Below is the error that comes in the SAS job logs??? ERROR: java.util.concurrent.TimeoutException Could not open connection to jdbc:hive2://XXXX:10000/ston. Check your Hive server status and also set option SUBPROTOCOL= appropriately. Set SUBPROTOCOL=hive2 if you are running HiveServer2. Set SUBPROTOCOL=hive if you are running Hive1. As per SAS engineers, tThe error likely indicates a shortage of connections are available. These values are the default ones that affect the number of connections: hive.metastore.server.min.threads=200 hive.metastore.server.max.threads=100000 hive.server2.thrift.min.worker.threads=5 hive.server2.thrift.max.worker.threads=100 SAS uses 2 connections when connecting to Hive. One primary connection and a secondary utility connection. Both connections remain until a Libname connection is cleared. The "hive.server2.thrift.max.worker.threads" property controls the number of connections which can be active at any one time... Can anyone help me in this how we can resolve the issue, is there is any effect on changing the default values of hive.server2.thrift.max.worker.threads? BR, Salman
... View more
Labels:
- Labels:
-
Apache Hive
05-23-2017
01:10 AM
Dear All, My client is going to upgrade from 5.4 to 5.8 CDH. The upgrade is being performed by the upgrade team using parcels. I hope it will be a rolling upgrade. Can anyone guide me that what are the post/pre upgrade steps that Hadoop administrator needs to perform or nice to have? Any document/link that will help me??? Cheers.
... View more
Labels:
- Labels:
-
Cloudera Manager
05-23-2017
01:01 AM
1 Kudo
Hi, Apologies for the late response. I've tried the above solution but they didt worked for me. An after number of times I have found the resolution. As database has a table with same name, due to that the problem is occuring. For example: We have a database test and in the same database we have a table test so Ive rename the table to test_2. We have successfully recreated this problem and also resolved the same on in test cluster. So thanks for the help and response. BR
... View more
11-16-2016
05:55 AM
Hi, I have tried to drop and recreate the same table. but still I am facing the same issue. I have made same tables like issue database in temp database that is pointing to the same file directory as in issue database table. This table worked fine without any error and able to show data, describe data etc. Then I have made the same table in issue database with the same configuration but it gives us the same error that I am facing. So I am facing this issue only in one database. Any Help!!! BR, Salman...
... View more
11-07-2016
10:47 PM
Thanks Romainr, Actually, when I tried to execute the describe query in HUE-Hive Editor, it executed fine. But when I tried to click table (on left panel of the HUE-Hive editor, in which we have to select database and below that we got list of tables), then it gives me the error. Other tables in databases works fine when I tried to execute the same query (Both in query editor and left table list panel). I hope It will clear it more. Best Regards Salman
... View more
11-07-2016
12:04 AM
HI All,
I am unable to run the simple query on HIVE i.e. describe tablename; and getting the below error. Also when I tried to check it on hue it also give me the same error. Even Ive tried to do the same with admin user and it gives me the same error. can anybody help me here.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. cannot find field lbs_retail_celleliste_jakntest from [0:id, 1:timestamp, 2:lid, 3:kundenr, 4:kundenavn, 5:gadenavn, 6:husnr, 7:postnr, 8:postdistrikt, 9:kisnr, 10:kismoder, 11:kismoder_navn, 12:sys34_x, 13:sys34_y, 14:celle_01_y, 15:celle_02, 16:celle_03, 17:celle_04, 18:celle_05, 19:celle_06, 20:celle_07, 21:celle_08, 22:celle_09, 23:celle_10, 24:utm_e, 25:utm_n]
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Hue