Stack Overflow
Stack Overflow

Questions tagged [tbl-properties]

Hive table properties clause used to define the (meta) properties of a hive table.

The TBLPROPERTIES clause allows you to tag the table definition with your own metadata key/value pairs. Some predefined table properties also exist, such as last_modified_user and last_modified_time which are automatically added and managed by Hive.

Other predefined table properties include:

TBLPROPERTIES ("comment"="table_comment")
TBLPROPERTIES ("hbase.table.name"="table_name") – see HBase Integration.
TBLPROPERTIES ("immutable"="true") or ("immutable"="false") in release 0.13.0+ (HIVE-6406) – see Inserting Data into Hive Tables from Queries.
TBLPROPERTIES ("orc.compress"="ZLIB") or ("orc.compress"="SNAPPY") or ("orc.compress"="NONE") and other ORC properties – see ORC Files.
TBLPROPERTIES ("transactional"="true") or ("transactional"="false") in release 0.14.0+, the default is "false" – see Hive Transactions.
TBLPROPERTIES ("NO_AUTO_COMPACTION"="true") or ("NO_AUTO_COMPACTION"="false"), the default is "false" – see Hive Transactions.
TBLPROPERTIES ("auto.purge"="true") or ("auto.purge"="false") in release 1.2.0+ (HIVE-9118) – see Drop Table and Drop Partitions.
6 questions
0
votes
0 answers

Code or tool to check last time a sql table was updated with result as date

Fairly new to SQL so please bear with... Trying to write SQL code or Rstudio function which will identify when a SQL table was last updated. Is there a way of using the CAST(FROM_UNIXTIME.... In the same SHOW TBLPROPERTIES statement so the result is…
Ray H
  • 1
0
votes
2 answers

Vacuuming Delta tables in Databricks does not work

I'm trying to vacuum my Delta tables in Databricks. However, somehow it is not working and I don't understand why. This is causing our storage constantly increasing. I have set the following table properties: %sql ALTER TABLE SET…
MCL94
  • 21
  • 1
  • 5
0
votes
2 answers

Hive converts Null to empty String in String Column

Hive converts Null to empty String in String Column. What is reason for that ? As per our requirement, we need to see Null in string column instead of empty String otherwise Is Null not working for those columns. So to solve this problem we set…
pardeep garg
  • 209
  • 1
  • 9
0
votes
1 answer

How to set tblproperties of hive table using hive-site.xml or how to create all table as transaction table by setting properties in hive-site.xml

I want to create HIVE table with the transactional table with TBLPROPERTIES ("transactional"="true") set using create table statement. instead of setting for all tables can I set TBLPROPERTIES using hive-site.xml.
Mahesh Gupta
  • 1,882
  • 12
  • 16
0
votes
0 answers

Hive and sqoop Export inserting NULL values when the columns have values

Im facing some issues while exporting or making queries on hive. I have a table while making a simple select * from table where column1='12345'; The values shows up in 2 lines and many of the fields have null values. While making this query. The…
macieira
  • 315
  • 2
  • 7
  • 18
0
votes
1 answer

Hive Table is empty?

What is the fastest way to check if a table has any records in Hive? I so far have come across these approaches: Do a SELECT count(*) FROM , I find this to be slow. Do a show tblproperties ("numRows");, I find that these…
Ani Menon
  • 27,209
  • 16
  • 105
  • 126