About ssahi

ssahi · ‎08-21-2017

Hi @zkfs I haven't seen a query to do that yet in Hive. Instead, you can query the hive metastore for the information, though be mindful that queries run directly against the metastore could impact your hive performance and are not recommended for production systems. Look at the TBL_PRIVS and TBLS within the hive DB in the metastore, joining these on the TBL_ID may give you the table view you are looking for. You can probably construct a similar metastore query to look at it from a PRINCIPAL_TYPE (role) as well.

ssahi · ‎08-21-2017

Hi @Dominik Ludwig I don't believe the current implementation of Ambari allows for it to manage multiple clusters yet. The Ambari Views framework is an extensible framework, and does allow you to write your own View if you would like. You can find more details on the framework itself on the Apache website: https://cwiki.apache.org/confluence/display/AMBARI/Views including some examples of views implementations I believe.

ssahi · ‎08-18-2017

Hi @Dominik Ludwig I haven't seen hard limits yet, how many clusters would you be trying to add? By the way, the feature is more about hosting Views for another cluster vs managing the operations of a remote cluster.

ssahi · ‎08-17-2017

Hu @Lucy zhang My colleague has a nice blog post showing to do this in sqoop here: http://blog.ervits.com/2015/03/running-saved-sqoop-144-jobs-with.html

ssahi · ‎08-17-2017

hi @zkfs the int field you see is the grantttime (in unix timestamp) when the grant was assigned.

ssahi · ‎08-16-2017

hi @nfleming The property can be set on a per session basis I believe. The Ambari Tez View shows the query run, and if you click on the config tab, you can see the Tez properties for that query.

ssahi · ‎08-16-2017

I believe these are internal repos

ssahi · ‎08-14-2017

hi @Sandeep Thumma You can use Oozie Coordinators to schedule by time. Here is a link to more on Oozie, and a blog post that contains a time-based example. https://hortonworks.com/apache/oozie/ https://hortonworks.com/blog/new-in-hdp-2-more-powerful-scheduling-options-in-oozie/

ssahi · ‎08-10-2017

Hi @M R I don't believe there is an existing NiFi processor to transpose rows to columns. You would likely have to write your own script to do this, and invoke it via the NiFi processor ExecuteScript.

ssahi · ‎08-10-2017

Hi @John Kuchmek I think currently out of the box CDC in the latest NiFi works with MySQL using the CaptureChangeMySQL processor. It is likely that the community is working on more CaptureChange processors in future versions. That said, you might be able to follow what was written in this blog post with NiFi to achieve a similar result: https://hortonworks.com/blog/change-data-capture-using-nifi/

Online	Offline
Last Visited	‎08-29-2019 11:23 AM

Member Since	‎08-23-2016 04:51 AM
Last Visited	‎08-29-2019 11:23 AM
Posts	261
Kudos received	194

Cloudera Community

Re: Hiveserver2 Interactive (Hive2) High Availabil...

Re: Does phoenix query server support connectivity...

Re: How to check Kafka version

Re: Run HIVE queries in command shell (cmd), not i...

Re: HDP and Ambari releases for HDPCA Exam

Re: Query to find Grant time/data/ on object from ...

Re: How many remote Clusters can be configure in o...

Re: How many remote Clusters can be configure in o...

Re: How to use sqoop password-alias together with...

Re: Query to find Grant time/data/ on object from ...

Re: Setting within script hive.tez.container.size

Re: HDP sandbox not able to connect 127.0.0.1:8888...

Re: How to schedule a workflow to run on first sun...

Re: NiFi: Pivot: Columns to Rows

Re: Change Data Capture for Hana View using NiFi