About pminovic

pminovic · ‎02-07-2016

Hi @Rupinder Singh, and welcome to HCC! We need more details to help you with your Hive view: Can you click on one of those "Syntax error" lines and attach the screenshot together with the screenshot of you Hive view settings. Also, can you tell us: Your version of HDP and Ambari, are you using Namenode HA, and your Hive port and Hive transport (binary or http). And by the way, can you list default Hive db from the command line? Tnx.

pminovic · ‎02-06-2016

Hi @Gerd Koenig, can you check the status of Ranger as seen by Ambari: curl -iv -u admin:admin -H "X-Requested-By:ambari" http://<ambari-server>:8080/api/v1/clusters/<cluster-name>/services/RANGER and component URLs http://<ambari-server>:8080/api/v1/clusters/<cluster-name>/services/RANGER/components/RANGER_ADMIN http://<ambari-server>:8080/api/v1/clusters/<cluster-name>/services/RANGER/components/RANGER_USERSYNC The state of the service should be STARTED, and of components INSTALLED. It looks like your components are in UNKNOWN state. If so, you can go to the Ranger host page in Ambari and see can you reinstall Ranger components. I had a similar issue before, on Ranger Admin only, caused by wrong Ranger DB connection setup, and it didn't go away after fixing the DB. Had to delete the service using REST API calls and reinstall Ranger from Ambari. Hopefully you don't have to do all that.

pminovic · ‎02-05-2016

Cute pic! And everything looks good, however, even in the "Light Storm, Kafka" case I'd create a dedicated Kafka ZooKeeper and put it on Kafka brokers, so that ZKs write to their own disks (for example, 5 disks for Kafka, 1 for ZK).

pminovic · ‎02-04-2016

Here is a Pig word count with comments. Give the delimiter to TOKENIZE, in you case comma: TOKENIZE(line,','). You might have to select a different filter based on your input. You can start by commenting the filter out and adding it later if needed. Finally, to extract only 10 top entries you can use LIMIT: top10 = LIMIT ordered_word_count, 10. Be sure to inspect the stored file and make sure words (tags) have been properly tokenized. If not, add a filter mentioned above.

pminovic · ‎02-03-2016

Have you taken a backup of your Ambari DB before Ambari upgrade? If so, you can uninstall your new version of ambari-server and ambari-agents on all nodes, delete the ambari database (by default it's called ambari, usually in Postgres), restore your DB backup, and re-install your old version of Ambari. You can also upgrade HDP-2.0 to 2.1 manually, here is the manual, and you can even upgrade manually to 2.2.

pminovic · ‎02-03-2016

Hi @Wesy Zhao the command to use is "zkServer.sh status". If it still shows zk as not running then check ZooKeeper log, the location appears in Ambari zookeeper-env. If this is the first time starting ZK then there might be permission issues on ZooKeeper directories on ZK hosts, ports not accessible etc., you will see what the log says.

pminovic · ‎02-02-2016

@Roberto Sancho See my comment above, you need to set hive.security.authorization.enabled to true, so replace false by "true", then restart Hive and retry grant commands.

pminovic · ‎02-02-2016

Your syntax is wrong, USER in "TO USER <user-name>" is required.

pminovic · ‎02-02-2016

Do GRANTs work on your cluster? Have you done them before? You must have hive.security.authorization.enabled=true and optionally hive.security.authorization.createtable.owner.grants=ALL

pminovic · ‎02-02-2016

Hi @Roberto Sancho you can do what @Ancil McBarnett suggested, or you can give "grant option" to user bigotes. As the Hive service user (most likely "hive") hive> grant ALL on TABLE logs to USER bigotes WITH GRANT OPTION; Or you can give such permission to the database which contains table "logs". After this user bigotes can grant permissions to other users on this table. Note that Hive authorization is not completely secure. It's intended to prevent good user from accidentally doing bad things, it won't prevent bad users from doing bad things. Full specs is here.

Online	Offline
Last Visited	‎08-19-2019 01:20 AM

Member Since	‎09-24-2015 04:02 AM
Last Visited	‎08-19-2019 01:20 AM
Posts	816
Kudos received	481

Cloudera Community

Re: datanode + Error occurred during initializatio...

Re: Problem when Distcp between two HA Cluster.

Re: Beeline over KNOX fails with HTTP Response co...

Re: What does nclients option of performance evalu...

Re: missing directories in ambari installation pac...

Re: hive view not exploring default databases ?

Re: Ranger services "Heartbeat lost" in Ambari, no...

Re: Best Practices for Storm Deployment on a Hadoo...

Re: top function in pig/hive

Re: Downgrade of Ambari 2.2 to 2.1

Re: Ambari Web start zookeeper successfully, but U...

Re: hive error GRANT PERMISSIONS

Re: hive error GRANT PERMISSIONS

Re: hive error GRANT PERMISSIONS

Re: hive error GRANT PERMISSIONS