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 | |
4046 | 05-01-2020 12:23 AM | |
2127 | 04-21-2020 03:38 PM | |
2094 | 04-14-2020 12:26 AM | |
1718 | 02-27-2020 05:51 PM |
01-20-2019
03:58 PM
I am not familiar with Microsoft SQL, so I am still not sure which while loop you meant. But most likely not supported in Impala.
... View more
01-17-2019
10:46 PM
All right, so it works on functions, but your query: REFRESH FUNCTIONS db_name Seems like against DB, shouldn't it be: REFRESH FUNCTIONS db_name.function_name you will firstly need access to db_name to be able to run refresh.
... View more
01-17-2019
04:52 PM
I believe REFRESH only works for tables, not on functions or DB. Can you try to run REFRESH {tablename} to confirm? To update other metadata, INVALIDATE METADATA is needed, which will need server level privilege.
... View more
01-17-2019
04:50 PM
1 Kudo
It is true for Impala, but not in HS2. I have requested our DOC team to update it. After HA enabled for HS2, you can still connect to HS2 instance directly, the only thing to be sure is that you need to use the LB's principal, not HS2 host's principal. Hope that helps.
... View more
01-17-2019
03:03 PM
You will need at least write access to the table that user need to refresh. Have you tried to run: GRANT ALL ON {db}.{table} TO ROLE {rolename}? where {rolename} should be assigned to the user/group.
... View more
01-17-2019
02:49 PM
1 Kudo
Currently CM only supports one LB setting in both Hive and Impala configuration, your idea of two active LBs is not supported. When LB fails, you can always connect directly to each HS2 if needed. Hope above helps.
... View more
01-16-2019
11:01 PM
Have you added partitions to those tables? If not, then PARTITIONS table will certainly be empty. Try to add partitions first and then check those tables. Same for Indexes. I haven't be able to find where the primary key being stored, still checking. Do not think Hive supports default values.
... View more
01-16-2019
02:47 PM
1 Kudo
1. old setting is mapred.job.queue.name, new one is mapreduce.job.queuename 2. I am sure _SUCCESS will be ignored, but not sure about others. Easiest way is to test them out 🙂 Cheers
... View more
01-15-2019
11:03 PM
1 Kudo
Why do you think catalog server does not need CPU? Catalog daemon needs to load lots of metadata information and it needs power to do so and it could be very intensive depends on how much metadata you have from Hive.
... View more
01-15-2019
11:01 PM
The whole stacktrace is pointing to Spotfire classes, looks like Spotfire issue. What's the exact error you get from Impala side? What query was run? Do you have PROFILE of the failed query to share?
... View more