Member since
04-19-2018
24
Posts
0
Kudos Received
0
Solutions
07-02-2018
03:03 PM
I will try this @Sindhu and shall confirm.
... View more
07-01-2018
05:23 AM
Could you provide steps to enable high availability for HIVE Metastore with MariaDB. Please let me know how to specify new database node name in addition to existing one in HIVE configs of Ambari.
... View more
Labels:
07-01-2018
05:19 AM
@mqureshi @sunile.manjee @Max Marwan What did you specify against DB in Hive configs in ambari? Can we specify the database nodes separated by semi colon? Can you add steps of doing that as well please.
... View more
07-01-2018
04:34 AM
@naveen sangam I have the same question. How did you do it finally?
... View more
06-27-2018
05:51 PM
I have an expression like HA^G^FER$$JY I would like to replace the all ^ with $. How do I do it. I tried all methods but this isn't working. Most common error I get is : java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
... View more
Labels:
06-25-2018
08:58 PM
How to set up common URL for MYSQL HA against AMBARI DB, HIVE DB etc. I read about VIP but how to implement that?
... View more
Labels:
06-25-2018
08:39 PM
Also please let me know if we can have a common URL to automatically resolve the active MYSQL node. @jigar.patel
... View more
06-25-2018
08:02 PM
Can you please provide me the actual working steps then. I need to enable MYSQL HA for my cluster here. @Shawn Weeks
... View more
06-25-2018
08:00 PM
Can you please provide me the steps for enabling high availability of MYSQL DB. I tried to follow: https://community.hortonworks.com/articles/92023/high-availability-for-mysql-database.html But the comments says this may not be the right method.
... View more
Labels:
06-25-2018
07:56 PM
Doe this actually work. I have to do this in my current organization.
... View more
06-19-2018
08:14 PM
How to assign privileges to a group when it is created?
... View more
05-29-2018
09:32 PM
All this while I have been using hive 1.5 and it has been working fine. I recently enabled hive view 2 but its acting differently.First its very very slow. When I choose a database it comes up after a minute or two. Sometimes it gives me a message on the browser that the webpage is taking too much memory.Even when I type queries the words I type takes a long time to appear. What could be the issue. Just to ensure, I have all queries working fine using beeline or hive view 1.5. Its just that I have all these issues with hive view 2.0.
... View more
Labels:
05-29-2018
09:24 PM
do you have any update. I am facing the same problem. @Neha Nirmal
... View more
05-23-2018
10:37 PM
Thats a good point. I would like to restrict save for all users. Can you tell me what needs to be manipulated to disable it.
... View more
05-23-2018
10:01 PM
I am not tlking about the saved queries. I am saying about the query results itself. There is a option to download the results to HDFS / csv. I don't want my user to do that. I would want to restrict them from downloading any production data results.
... View more
05-23-2018
09:43 PM
I have a hive view user and wouldn't want him to save the query results. How should I go about restricting him from doing it.
... View more
Labels:
05-16-2018
08:36 PM
So I identified that this is a bug which they will fix only in HDP 3. Looks like there is work around which worked on HDP 2.6.0 but it stopped working in 2.6.1. I upgraded my stack to 2.6.2 and it works fine now.
... View more
05-16-2018
06:48 PM
This can happen if spark1 and spark2 are both running on same node.Try to kill the process. Then delete the service and add it to a separate node.It must work.
... View more
05-04-2018
02:11 PM
I have a requirement where I need to move the Ranger logs accumulated in HDFS to Amazon S3. How can I make this work. Alternately can I accumulate the logs in S3 itself going forward. Is that an option?
... View more
Labels:
04-27-2018
02:19 PM
Thanks @vperiasamy for your input. I have some questions: 1. how do I pass a condition like requestUser<>hive, so it gives me information of all other user except hive. 2. This being in JASON format, I assume I may have to pass it to a visualization tool to make it presentable. Right? 3. Is there a provision within Ranger where I can embed this so I can see it like a dashboard.
... View more
04-27-2018
11:11 AM
I get the following error: <?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader"><int name="status">400</int><int name="QTime">1</int></lst><lst name="error"><lst name="metadata"><str name="error-class">org.apache.solr.common.SolrException</str><str name="root-error-class">org.apache.solr.parser.ParseException</str></lst><str name="msg">org.apache.solr.search.SyntaxError: Cannot parse 'evtTime:[* TO NOW- 7DAYS]': Encountered " <RANGE_GOOP> "7DAYS "" at line 1, column 19.
Was expecting one of:
"]" ...
"}" ...
</str><int name="code">400</int></lst>
... View more
04-26-2018
10:50 PM
We would like to use ranger audit to HIVE to track HIVE View user activity alone. Currently when I enable Ranger Plug in for Hive it logs activity of all Hive users. Predominantly, I see the access log of edge node user the most since thats used to run the scheduled jobs.We have around 20 HIVE View users and it becomes difficult for me to add each of these users in filter to get their results. Here is what I am thinking.Either of these options will help me: 1. Can I modify the solr query to isolate the edge node user? 2. Can I filter the results by saying "User <> edgenodeuser" 3. Can I create a custom ranger audit report. But how? Thanks, Abhi
... View more
Labels:
04-26-2018
08:31 PM
Thank you so much!!
... View more
04-19-2018
03:36 PM
@Rodrigo Rondena I am having the same problem. There is full access but still I get an error with having a temporary function. Please let me know what else I can try. I was also not able to find the JIRA that @jbarnett mentioned. , @Rodrigo RondenaWere you able to find a solution? I have the same problem.
... View more