@Timothy Spann Were you able to configure TOAD with a kerberized cluster? ... View more

Hi Ali - With HDP2.5 Ambari can be used for this installation right? I am confused between : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.0/bk_solr-search-installation/content/ch_hdp-search-install-ambari.html and https://doc.lucidworks.com/lucidworks-hdpsearch/2.5/Guide-Install-Ambari.html Do i have to do the first and then do the second ? ... View more

With HDP 2.5 we need to use the jdbc connectors instead of the %sql or hive. However we had to do the following prior to getting this to work. in /usr/hdp/current/zeppelin-server/interpreter/jdbc either copy the hive, hadoop and phoenix jars or create soft links for the same Since all the sample notebooks use the %sql or %hive they would not work. you will need to use %jdbc(phoenix) or %jdbc(hive) as appropriate. Once you do this restart the jdbc interpreter >pwd /usr/hdp/current/zeppelin-server/interpreter/jdbc > ls -l hive-jdbc.jar -> /usr/hdp/current/hive-client/lib/hive-jdbc-1.2.1000.2.5.0.0-1245-standalone.jar hadoop-common.jar -> /usr/hdp/current/hadoop-client/hadoop-common-2.7.3.2.5.0.0-1245.jar phoenix-core-4.7.0.2.5.0.0-1245.jar /usr/hdp/current/phoenix-client/lib/phoenix-core-4.7.0.2.5.0.0-1245.jar ... View more

PDFs are 50KB Max. and each rowkey can have upto a max of 5 PDFs associated with it. And the total volume of records would be around 500K range. Like you suggest we have 2 column Families, one for the metadata and one for the documents. your suggestion actually gives a vote of confidence to our thought process. ... View more

^ Great Article. 1.If you have a secured cluster managed by ranger ensure ambari-qa user has access to root.default queue. Many of our validations during the upgrade failed due to this. The SQL mentioned in the above article helped when we could not finalized the upgrade. Couple of components were stuck in State = 'UPGRADING'. The hdp-select did show the right versions. A Restart of ambari-agent on those nodes cleared this up. all the records were updated to upgraded and wer were able to proceed. SELECT rv.version, h.host_name, hv.state FROM repo_version rv JOIN host_version hv ON rv.repo_version_id = hv.repo_version_id JOIN hosts h ON hv.host_id = h.host_id where (STATE NOT IN ('CURRENT','UPGRADED') OR STATE='UPGRADING') ORDER BY rv.version ASC, h.host_name; ... View more

In case of oracle metastore , the query would to run from SQL Developer or TOAD would be : SELECT 'show create table' || dbs.name || '.' || tbls.tbl_name || ';' FROM tbls LEFT JOIN dbs ON tbls.db_id = dbs.db_id ... View more

Hi Neeraj - Thanks for the post. Since current HDP doesn't ship with Drill , would it be reasonable to expect using the Drill ODBC Driver for HBASE Connectivity from Excel and other BI tools ? ( though its more of a MAPR Focus?) I would rather maintain one ODBC Driver vs having Drill for HBASE and HDP ODBC for Hive. ... View more