Member since
03-23-2015
1288
Posts
114
Kudos Received
98
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2521 | 06-11-2020 02:45 PM | |
4049 | 05-01-2020 12:23 AM | |
2129 | 04-21-2020 03:38 PM | |
2095 | 04-14-2020 12:26 AM | |
1718 | 02-27-2020 05:51 PM |
03-09-2019
10:51 PM
From the warning message: set_ugi() not successful, Likely cause: new client talking to old server. Continuing without it. org.apache.thrift.transport.TTransportException This issue can occurs when hive-site.xml used by job is not in sync with the server. Could you please confirm if the "hive-site.xml" passed in the job was updated, can you please confirm that hive-site.xml file is the correct one? Have you also checked on HMS side? What did HMS server log complain? Is your HS2 working correctly with HMS? What about Hive CLI? Cheers
... View more
03-07-2019
02:21 PM
Hi, Can you please share your query that has the LATERAL VIEW? This can help to see if you have any issues on your query.
... View more
03-07-2019
01:31 AM
I realise that the krb5.conf file is under /etc/krb5.conf, which is on Linux host, not Windows. What's the content of your krb5.conf on your Windows machine?
... View more
03-06-2019
12:37 AM
1 Kudo
HMS does not currently support Load Balancing. You can only specify them in order in hive-site.xml and it will fall to the second HMS only when first HMS is not reachable.
... View more
03-06-2019
12:26 AM
It sounds like your Windows is not able to communicate with KDC server. Your KDC is set as "quickstart.cloudera", can you ping quickstart.cloudera from your Windows laptop to see if you can response?
... View more
01-24-2019
07:46 PM
2 Kudos
I am not sure if there are easier ways, but something like below might work: SELECT CASE DAYOFWEEK(NOW()) WHEN 1 THEN DAYS_SUB(NOW(), 2) -- Sunday, so Friday was 2 days ago WHEN 2 THEN DAYS_SUB(NOW(), 3) -- Monday WHEN 3 THEN DAYS_SUB(NOW(), 4) -- Tuesday WHEN 4 THEN DAYS_SUB(NOW(), 5) -- Wednesday WHEN 5 THEN DAYS_SUB(NOW(), 6) -- Thursday WHEN 6 THEN DAYS_SUB(NOW(), 7) -- Friday WHEN 7 THEN DAYS_SUB(NOW(), 1) -- Saturday, so Friday just the day before END AS last_friday; If you just want the Friday from last week, regardless of which day you are on, then below might be easier: SELECT DAYS_SUB(NOW(), DAYOFWEEK(NOW()) +1) AS last_friday; Hope above helps.
... View more
01-24-2019
07:30 PM
Can you share your code that connects to impala? I had some examples here: https://github.com/ericlin05/impyla-examples/blob/master/impala-kerberos.py But it was a while back and I am not sure if it is still working with latest Impala.
... View more
01-21-2019
10:26 PM
Let me check this internally for you. Will get back to you later on this.
... View more
01-21-2019
03:08 PM
Sorry, I am not aware of this. Is there any particular use case that you need to rely on this feature?
... View more
01-20-2019
04:00 PM
1 Kudo
UPDATE statement in Impala? Are you using KUDU as the underlining table? If not, then UPDATE is not supported. Please refer to below link: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_update.html "This statement only works for Impala tables that use the Kudu storage engine."
... View more