About bbreak

bbreak · ‎02-16-2017

Thanks for asking about this. The m ax message size for Hive Metastore should be set to 10% of the Metastore server heap size, up to a maximum of 2,147,483,647 bytes. Unfortunately, the values used or displayed by that configuration validator may be incorrect in some cases. Until that's fixed, I recommend checking the actual HMS heap size and configuring the max message size accordingly.

bbreak · ‎02-08-2017

Here's what the most recent version of the CDH Hive documentation says about this: http://www.cloudera.com/documentation/enterprise/latest/topics/hive.html#hive_transaction_support "Transaction (ACID) Support in Hive The CDH distribution of Hive does not support transactions (HIVE-5317). Currently, transaction support in Hive is an experimental feature that only works with the ORC file format. Cloudera recommends using the Parquet file format, which works across many tools. Merge updates in Hive tables using existing functionality, including statements such as INSERT, INSERT OVERWRITE, and CREATE TABLE AS SELECT."

bbreak · ‎12-01-2016

Hi Kailash, The security browser in Hue shows privileges that have been granted on Hive tables. That's what appears in the screenshot you provided, and that's what it's supposed to do. I'm not sure what you mean by "Sentry tables." The tables that Sentry is concerned with are in Hive, so this is normal behavior. I hope this helps.

bbreak · ‎07-07-2016

Hi LeoS, Can you advise what command you're running that results in this error? Thanks!

bbreak · ‎06-20-2016

The bit was an attempt to format the post. It wasn't supposed to be part of the query, sorry about that. Try adding "as" after "create table tester" and before the nested select query.

bbreak · ‎06-17-2016

Hi Lucille, For the example you provided, you could get the file names with a query like this: SELECT hive_magnum.col1, hive_magnum.col2, hive_magnum.col3, hive_magnum.INPUT__FILE__NAME FROM hive_magnum; It will actually provide the full HDFS location, which includes the file name. I hope this is helpful.

Online	Offline
Last Visited	‎08-12-2019 03:25 PM

Date Registered	‎02-08-2015 05:22 PM
Last Visited	‎08-12-2019 03:25 PM
Total Messages Posted	41
Total Kudos Received	3

Re: hive table compaction

Re: Add filename to import in Hive

Re: Cloudera Manager warning about Max Message Siz...

Re: hive table compaction

Re: Hive Tables instead Sentry Tables

Re: data load to hdfs using parquet file

Re: Add filename to import in Hive

Re: Add filename to import in Hive