Member since
07-31-2019
346
Posts
259
Kudos Received
62
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2681 | 08-22-2018 06:02 PM | |
1576 | 03-26-2018 11:48 AM | |
3887 | 03-15-2018 01:25 PM | |
4906 | 03-01-2018 08:13 PM | |
1354 | 02-20-2018 01:05 PM |
08-22-2018
06:02 PM
1 Kudo
Hi @Leonardo Araujo. Enabling ACID will not automatically convert existing tables to transactional tables. You will need to manually (or script) new CREATE TABLE statements with the TRANSACTION property and then insert data into those tables. Be aware of existing requirement for transactional tables such as ORC format and bucketing. In HDP 3.0, all Hive managed tables are ACID by default.
... View more
07-30-2018
12:28 PM
@Sanaz Janbakhsh Hive CLI is deprecated. We suggest using beeline. There is work being done on a more robust SQL IDE that provides significantly more functionality than the Hive view.
... View more
07-10-2018
01:45 PM
@tauqeer khan I'd recommend upgrading to 2.6 prior to using LLAP in production.
... View more
07-05-2018
04:20 PM
Hi @Vinay Khandelwal were you able to find a solution to this problem? This case is a dated but I've recently seen others with similar issues and we are still trying to track down a resolution.
... View more
06-28-2018
08:35 PM
Check the firewall settings between subnets. The firewall may not be allowing the connection or timing out the connection.
... View more
05-15-2018
12:31 PM
Hi @Nick Xu. _col0 is the first column in the table definition. You can find out what it is by running "DESCRIBE <tablename>"
... View more
03-28-2018
02:25 PM
1 Kudo
Hi @Mushtaq Rizvi, that sounds like a creative and good idea. I'm glad you are working something out that others can learn from. Thanks for posting!
... View more
03-28-2018
01:59 PM
1 Kudo
Hi @Mushtaq Rizvi, in thinking outloud, if you are looking at the Hive metastore and its running Oracle, MySQL, or MariaDB, I supposed you could create standard triggers to notify you when something changes. I know this can be done in SQL Server but I haven't explored the other RBMS options. Be careful how how this would affect performance depending on the rate of change. I'm not aware of a solution native to Hive. Hive does not support triggers though there may be some better options once HPL/SQL is introduced into the Hive. Please update this post if you find another solution.
... View more
03-28-2018
01:49 PM
Hi @Sebastien F, are you referring to sampling data https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Sampling? I think I need a little more clarification in order to better help.
... View more