About bandarusridhar1

asreekumar · ‎07-13-2017

If the issue is that the number of rows is too high starting beeline with beeline --incremental=true will be of help

ssubhas · ‎07-26-2017

@Dhiraj Then, you need to run 'Drop database cascade'.

bandarusridhar1 · ‎07-12-2017

@Sami Ahmad For changing the Ranger Admin password, we need to change the password in 3 different locations. 1. In Ambari you need to change the password at highlighted places: 2. Login to ranger using admin/admin, click on the profile at right-top, then click on change password. Below screenshot helps you to navigate Note: Password should be same across all the places and it should be minimum 8 characters. Hope this helps you.

sunil_kantilal · ‎10-23-2018

Its better not to disturb the properties on the statistics usage like hive.compute.query.using.stats. It impacts the way the statistics are used in your query for performance optimization and execution plans. It has tremendous influence on execution plans, the statistics stored depends on the file format as well. Therefore definitely not a solution to change any property with regards to statistics. The real reason for count not working correctly is the statistics not updated in the hive due to which it returns 0. When a table is created first, the statistics is written with no data rows. Thereafter any data append/change happens hive requires to update this statistics in the metadata. Depending on the circumstances hive might not be updating this real time. Therefore running the ANALYZE command recomputes this statistics to make this work correctly.

bandarusridhar1 · ‎06-15-2017

@vperiasamy Thanks for confirm that Ranger ACL will work as-is. I will debug on it. Thanks for the help, you are the best... 🙂

Bittu · ‎07-28-2018

The script in the blog scans through all the databases on the Hive system, and routes all 'Create' Table statements to a file.. https://tips-to-code.blogspot.com/2018/07/automated-bash-script-to-export-all.html

nord_tramper · ‎06-01-2017

@spolavarapu thank! It is exactly my case

bandarusridhar1 · ‎05-26-2017

@Saransh Sharma In addition to @Binu Mathew If you don't want to take separate backups, and there are limited table to take, even you can use Hive Import/Export option. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport

bandarusridhar1 · ‎06-02-2017

Thanks @Josh Elser The encoding is done intentionally and hence there is no way to disable/suppress it from REST API Calls, if you wanna do decode it, we need to write Java code accordingly. here is the link: https://hbase.apache.org/book.html#_running_the_shell_in_non_interactive_mode

Sreedhar_ch · ‎07-16-2018

Guys there is challenge I am facing .. when I am running the snapshotdiff from a remote cluster it is failing with snapshot not found error even though it is available .. do we have any solution for this .. we built a DR cluster and running distcp from DR to utilize the DR resources instead of overloading the PROD .. any solution how this can be achived..