Page History

View, compare, or restore historical versions of this page. Older versions may be automatically deleted based on rules set by your administrator.

Version	Published	Changed By	Comment
CURRENT (v. 355)	Apr 21, 2023 13:16	László Végh
v. 354	Feb 23, 2023 09:40	László Végh
v. 353	Jul 22, 2022 09:08	Stamatis Zampetakis	HIVE-25039: Automatic partition discovery is not enabled by default
v. 352	Apr 30, 2021 17:43	Naveen Gangam
v. 351	Apr 14, 2021 15:30	Zoltan Haindrich
v. 350	Apr 06, 2021 18:52	Naveen Gangam
v. 349	Oct 28, 2020 14:00	David Mollitor
v. 348	Oct 28, 2020 13:59	David Mollitor
v. 347	Jun 16, 2020 09:57	Miklos Gergely
v. 346	May 08, 2020 21:01	Naveen Gangam
v. 345	May 08, 2020 20:49	Naveen Gangam
v. 344	Apr 23, 2020 12:29	Miklos Gergely
v. 343	Apr 15, 2020 02:22	David Mollitor	Added information about optional TABLE token in TRUNCATE statement
v. 342	Apr 14, 2020 06:00	zhihuadeng
v. 341	Apr 14, 2020 05:37	zhihuadeng
v. 340	Feb 03, 2020 16:23	Zoltan Haindrich	add link to scheduled queries docs
v. 339	Sep 26, 2019 00:32	Vineet Garg
v. 338	Sep 08, 2019 05:00	user-77895
v. 337	Sep 08, 2019 05:00	user-77895
v. 336	Sep 08, 2019 04:56	user-77895
v. 335	Sep 08, 2019 04:51	user-77895
v. 334	Sep 08, 2019 04:45	user-77895
v. 333	Jul 08, 2019 17:13	Miklos Gergely
v. 332	Jun 27, 2019 12:09	Miklos Gergely
v. 331	Jun 27, 2019 12:08	Miklos Gergely
v. 330	Jun 09, 2019 09:34	Prasanth J Nickolay Ponomarev
v. 329	Apr 10, 2019 23:21	Thejas Nair
v. 328	Apr 10, 2019 23:18	Thejas Nair	doc external.table.purge
v. 327	Jan 09, 2019 18:55	user-77895
v. 326	Jan 09, 2019 18:54	user-77895
v. 325	Nov 10, 2018 03:58	Lefty Leverenz	add internal link for managed table
v. 324	Nov 02, 2018 12:27	Lars Francke	Move description of managed vs external tables to their own page
v. 323	Sep 19, 2018 23:52	Janaki Lahorani
v. 322	Sep 19, 2018 02:29	Eugene Koifman
v. 321	Sep 19, 2018 02:28	Eugene Koifman
v. 320	Aug 30, 2018 11:09	Lars Francke	Minor formatting changes
v. 319	Jun 21, 2018 22:04	Aihua Xu
v. 318	Jun 21, 2018 22:01	Aihua Xu
v. 317	Jun 17, 2018 05:06	Lefty Leverenz	in Create View, change nonsupport for materialzed views to support in 2.3.0
v. 316	May 23, 2018 13:16	Ádám Szita	Update columns documentation
v. 315	Mar 22, 2018 12:29	Madhudeep Petwal	SHOW COLUMNS
v. 314	Feb 20, 2018 07:58	Lefty Leverenz	restore header for Bucketed Sorted Tables
v. 313	Feb 16, 2018 21:07	Eugene Koifman
v. 312	Oct 16, 2017 23:13	Thejas Nair	fix abort txn doc - supports space, not comma
v. 311	Sep 26, 2017 16:24	Eugene Koifman
v. 310	Sep 21, 2017 00:51	Lefty Leverenz	make "Show Partitions" a Heading 4 so it's in the mini-TOC
v. 309	Aug 15, 2017 18:29	Mithun Radhakrishnan
v. 308	Aug 10, 2017 16:17	Barna Zsombor Klara	Removed reverted table property.
v. 307	Jul 20, 2017 05:57	Lefty Leverenz	update auto.purge & trivial edit in Truncate Table for HIVE-15880
v. 306	Jul 07, 2017 19:37	Steven Wong	Fix the syntax of Add Partitions.
v. 305	Jun 04, 2017 04:42	Lefty Leverenz	trivial edit: remove leading space in Additional Alter Table Statements heading
v. 304	May 31, 2017 00:03	Pengcheng Xiong
v. 303	May 20, 2017 05:41	Lefty Leverenz	update version for HIVE-16324
v. 302	May 19, 2017 04:46	Lefty Leverenz	add version for table property parquet.mr.int96.write.zone
v. 301	May 18, 2017 04:10	Lefty Leverenz	add links to listTableProperties anchor in Alter/Show Table Properties
v. 300	May 17, 2017 17:38	Vihang Karajgaonkar
v. 299	May 17, 2017 17:37	Vihang Karajgaonkar
v. 298	May 11, 2017 07:37	Rui Li
v. 297	May 07, 2017 08:57	Dudu Markovitz
v. 296	May 07, 2017 08:56	Dudu Markovitz
v. 295	May 07, 2017 08:54	Dudu Markovitz
v. 294	May 07, 2017 08:51	Dudu Markovitz	"dot (.) and colon (:) yield errors on querying ..." CREATE TABLE + ALTER TABLE
v. 293	Apr 19, 2017 15:59	Dudu Markovitz
v. 292	Apr 03, 2017 20:44	Vihang Karajgaonkar
v. 291	Apr 02, 2017 05:33	Lefty Leverenz	change links from "Create Table" to "listTableProperties" anchor in Drop Table and Drop Partitions
v. 290	Mar 10, 2017 02:14	Lefty Leverenz	change 0.15 to 1.1.0 in five places for HIVE-16158
v. 289	Mar 07, 2017 19:09	Eugene Koifman
v. 288	Mar 06, 2017 01:23	Lefty Leverenz	edit table property parquet.mr.int96.write.zone, add link to config
v. 287	Mar 01, 2017 09:42	Barna Zsombor Klara	Fix formatting for parquet.mr.
v. 286	Mar 01, 2017 09:41	Barna Zsombor Klara	Added parquet.mr.int96.write.zone property
v. 285	Jan 22, 2017 00:00	Carter Shanklin	Docs and example on constraints (create and alter)
v. 284	Dec 12, 2016 20:16	Anthony Hsu	Clarified source and destination tables for EXCHANGE PARTITION
v. 283	Dec 10, 2016 00:11	Lefty Leverenz	add anchor for old section "Row Format, Storage Format, and SerDe"
v. 282	Dec 08, 2016 23:54	Eugene Koifman
v. 281	Dec 04, 2016 06:50	Lefty Leverenz	minor edits & links in Managed and External Tables
v. 280	Nov 27, 2016 07:10	Lefty Leverenz	add version to SHOW TRANSACTIONS items for HIVE-11957
v. 279	Nov 23, 2016 21:25	Wei Zheng
v. 278	Nov 23, 2016 14:17	Zoltan Haindrich	Intervals: add keywords
v. 277	Oct 29, 2016 16:53	Andrew Sears	mention druid and accumulo for storage handlers
v. 276	Oct 29, 2016 11:59	Andrew Sears	Managed vs External Tables
v. 275	Oct 29, 2016 10:35	Andrew Sears	storage format cleanup
v. 274	Oct 29, 2016 10:31	Andrew Sears	csv/tsv format
v. 273	Oct 29, 2016 10:15	Andrew Sears	regex updates
v. 272	Oct 29, 2016 10:11	Andrew Sears	json update
v. 271	Oct 29, 2016 10:02	Andrew Sears	JSON Link
v. 270	Oct 29, 2016 09:58	Andrew Sears	json serde
v. 269	Oct 29, 2016 09:57	Andrew Sears	reformatting of storage formats, add rcfile and consolidate JSON page here
v. 268	Oct 29, 2016 07:35	Lefty Leverenz	explain "managed table" in Create Table section, with anchor "managedTable" for xrefs
v. 267	Oct 29, 2016 07:11	Lefty Leverenz	minor edits & new links in Rename Table for HIVE-14909
v. 266	Oct 28, 2016 14:33	Chaoyu Tang
v. 265	Oct 24, 2016 23:02	Alan Gates
v. 264	Oct 24, 2016 06:34	Lefty Leverenz	reformat table of keywords
v. 263	Oct 24, 2016 05:24	Lefty Leverenz	fix table of contents for Keywords sections
v. 262	Oct 21, 2016 07:21	Lefty Leverenz	trivial edits in Show Compactions
v. 261	Oct 16, 2016 18:55	Pengcheng Xiong
v. 260	Oct 16, 2016 18:54	Pengcheng Xiong
v. 259	Oct 16, 2016 18:53	Pengcheng Xiong
v. 258	Oct 16, 2016 07:58	Pengcheng Xiong
v. 257	Oct 16, 2016 07:36	Pengcheng Xiong
v. 256	Oct 12, 2016 20:21	Pengcheng Xiong
v. 255	Oct 10, 2016 13:56	Naveen Gangam
v. 254	Oct 08, 2016 06:12	Lefty Leverenz	add link to Show Views in Create View section; misc. edits in Show Views
v. 253	Oct 08, 2016 05:41	Lefty Leverenz	add an anchor (at end of previous paragraph) for old heading "Show Tables/Partitions/Indexes"
v. 252	Oct 04, 2016 14:56	Naveen Gangam	Added documentation for SHOW VIEWS
v. 251	Sep 14, 2016 08:42	Barna Zsombor Klara	Clarified that the file format alter statement only changes metadata.
v. 250	Sep 12, 2016 22:53	Lefty Leverenz	reformat Dynamic Partitions heading
v. 249	Sep 11, 2016 06:13	Lefty Leverenz	add version and link to HIVE-14626 in Truncate Table; trivial edits
v. 248	Sep 11, 2016 05:42	Lefty Leverenz	trivial change for consistency
v. 247	Sep 11, 2016 05:20	Lefty Leverenz	add version information to PRECISION keyword, redo line breaks as needed
v. 246	Sep 10, 2016 10:39	Zoltan Haindrich	add PRECISION keyword; add DOUBLE PRECISION to primitive_type -s
v. 245	Sep 09, 2016 15:08	Chaoyu Tang
v. 244	Sep 06, 2016 06:15	Lefty Leverenz	trivial edit: change hyphen to en-dash in Show Locks
v. 243	Aug 26, 2016 02:04	Eugene Koifman
v. 242	Aug 26, 2016 01:56	Eugene Koifman
v. 241	Aug 25, 2016 20:26	Eugene Koifman
v. 240	Aug 25, 2016 09:16	Lefty Leverenz	add an anchor (listTableProperties) for the TBLPROPERTIES bullet list
v. 239	Aug 25, 2016 09:10	Lefty Leverenz	trivial edit: change a dash to en-dash in TBLPROPERTIES list
v. 238	Aug 24, 2016 12:32	Kit Menke	Added EXTERNAL tblproperty
v. 237	Aug 24, 2016 11:03	Lalam Chinna Rao
v. 236	Aug 18, 2016 08:00	Lefty Leverenz	minor edits of docs for HIVE-13354 (compaction)
v. 235	Aug 15, 2016 22:07	Wei Zheng
v. 234	Aug 15, 2016 22:04	Wei Zheng
v. 233	Aug 15, 2016 21:38	Wei Zheng
v. 232	Aug 15, 2016 07:53	Lefty Leverenz	edit Abort Transactions
v. 231	Aug 11, 2016 22:17	Wei Zheng
v. 230	Aug 11, 2016 22:16	Wei Zheng
v. 229	Aug 05, 2016 23:29	Lefty Leverenz	add link from External Tables to Tutoria
v. 228	Jun 30, 2016 00:12	Shannon Ladymon	Minor edits
v. 227	Jun 30, 2016 00:07	Shannon Ladymon	Added version information for create view on HIVE-13736
v. 226	Jun 07, 2016 18:04	Anthony Hsu	Grammar: were -> was
v. 225	Jun 07, 2016 18:04	Anthony Hsu	Added info about RESTRICT and CASCADE for the DROP DATABASE statement
v. 224	Apr 05, 2016 02:14	Lefty Leverenz	add two more bug fixes to Create/Drop Macro section
v. 223	Apr 05, 2016 00:12	Shannon Ladymon	Minor edits
v. 222	Apr 05, 2016 00:11	Shannon Ladymon	Added version info about create macro
v. 221	Apr 05, 2016 00:01	Shannon Ladymon	Minor edits
v. 220	Apr 04, 2016 23:54	Shannon Ladymon	Added Create/Drop Macro
v. 219	Mar 31, 2016 00:04	Thejas Nair	example - describe partitions
v. 218	Mar 30, 2016 23:58	Thejas Nair	example for - show table extended
v. 217	Mar 30, 2016 19:31	Eugene Koifman
v. 216	Mar 21, 2016 22:37	Wei Zheng
v. 215	Mar 15, 2016 18:31	Andrew Sears	add comment to column syntax
v. 214	Mar 14, 2016 23:15	Shannon Ladymon	Added info on current_database() to Use Database
v. 213	Feb 20, 2016 08:25	Lefty Leverenz	minor edits to Exchange Partition section
v. 212	Feb 19, 2016 02:14	Andrew Sears	add multiple partitions with example
v. 211	Dec 23, 2015 23:21	Pengcheng Xiong
v. 210	Dec 23, 2015 21:31	Pengcheng Xiong
v. 209	Dec 10, 2015 23:17	Shannon Ladymon	Clarified the different syntax for describe with columns
v. 208	Dec 09, 2015 06:28	Lefty Leverenz	a bit more tinkering
v. 207	Dec 09, 2015 05:46	Lefty Leverenz	more tinkering
v. 206	Dec 09, 2015 05:42	Lefty Leverenz	minor touch-ups in Partitioned Tables section
v. 205	Dec 09, 2015 05:32	Lefty Leverenz	add titles to example boxes, minor edits
v. 204	Dec 09, 2015 01:38	Shannon Ladymon	Minor edits
v. 203	Dec 09, 2015 01:25	Shannon Ladymon	Added column option to describe partition
v. 202	Dec 06, 2015 04:45	Lefty Leverenz	remove version information for describe partition
v. 201	Dec 06, 2015 04:33	Lefty Leverenz	fix vertical whitespace in describe table syntax
v. 200	Dec 06, 2015 04:29	Lefty Leverenz	add version information to pre-2.0 describe table [partition] (HIVE-12184)
v. 199	Dec 02, 2015 18:13	Naveen Gangam	Added documentation for HIVE-12184
v. 198	Sep 24, 2015 01:23	Anthony Hsu	Added " [PARTITION partition_spec]" to Add SerDe properties examples
v. 197	Sep 08, 2015 06:25	Lefty Leverenz	fix formatting of Reserved Keywords heading
v. 196	Sep 08, 2015 06:17	Lefty Leverenz	add version information for REGEXP and RLIKE (HIVE-11703)
v. 195	Sep 07, 2015 20:40	Pengcheng Xiong
v. 194	Aug 27, 2015 23:12	Shannon Ladymon	(Updated jira for Drop Partition Purge)
v. 193	Jul 16, 2015 00:37	Alan Gates
v. 192	Jul 16, 2015 00:34	Alan Gates
v. 191	Jul 09, 2015 22:23	Lefty Leverenz	clarify a crossreference to Drop Partitions
v. 190	Jul 09, 2015 22:18	Lefty Leverenz	fix a link
v. 189	Jul 09, 2015 22:14	Lefty Leverenz	add links between Drop Partitions and Alter Table/Partition Protections
v. 188	Jun 29, 2015 21:36	Jason Dere	Document RELOAD FUNCTION
v. 187	Jun 13, 2015 02:40	Lefty Leverenz	Migrated to Confluence 5.3
v. 186	Jun 13, 2015 02:40	Lefty Leverenz	add hive.exec.temporary.table.storage in Temporary Tables (HIVE-7313)
v. 185	Jun 08, 2015 08:44	Lefty Leverenz	add links to hive.typecheck.on.insert
v. 184	Jun 02, 2015 17:37	Wei Zheng
v. 183	Jun 01, 2015 22:00	Lefty Leverenz	explain that msck means metastore check
v. 182	Jun 01, 2015 19:07	Sergey Shelukhin
v. 181	Jun 01, 2015 02:16	Nickolay Ponomarev	make it clearer that identifier_with_wildcards in SHOW must be quoted.
v. 180	May 01, 2015 02:40	Chaoyu Tang
v. 179	May 01, 2015 02:36	Chaoyu Tang	doc hive.typecheck.on.insert for describe partition
v. 178	May 01, 2015 02:30	Chaoyu Tang	doc hive.typecheck.on.insert
v. 177	Apr 20, 2015 04:30	Lefty Leverenz	revert change to heading level to fix toc
v. 176	Apr 20, 2015 04:24	Lefty Leverenz	add line breaks to keywords and version information, minor edits (HIVE-6617)
v. 175	Apr 14, 2015 17:56	Pengcheng Xiong
v. 174	Apr 08, 2015 20:06	Owen O'Malley
v. 173	Mar 24, 2015 21:08	Chaoyu Tang	db_name.table_name.column_name does not work in displaying column statistics
v. 172	Mar 09, 2015 10:12	Lefty Leverenz	revise Drop Partitions section
v. 171	Mar 09, 2015 09:53	Lefty Leverenz	reorganize purge option in Drop Table and Drop Partitions
v. 170	Mar 09, 2015 09:44	Lefty Leverenz	fix link to Drop Partitions from Drop Table
v. 169	Mar 09, 2015 09:36	Lefty Leverenz	fix PURGE syntax, add table property auto.purge (HIVE-7100, HIVE-9086, HIVE-9118)
v. 168	Feb 23, 2015 07:50	Lefty Leverenz	add Alter Table Skewed & Stored as Directories (HIVE-3072 and HIVE-3649); fix create table syntax
v. 167	Feb 20, 2015 08:38	Lefty Leverenz	fix a typo ("buckeing" -> "bucketing")
v. 166	Feb 19, 2015 09:52	Lefty Leverenz	document PURGE option for DROP TABLE or PARTITION (HIVE-7100)
v. 165	Feb 18, 2015 09:03	Lefty Leverenz	fix a typo in Create Function (db_name.funciton_name)
v. 164	Feb 18, 2015 07:45	Lefty Leverenz	fix link to Drop Partitions
v. 163	Feb 18, 2015 07:43	Lefty Leverenz	add link to Drop Partition section from Drop Table section
v. 162	Feb 18, 2015 07:33	Lefty Leverenz	add six links to hive.exec.drop.ignorenonexistent in Configuration Properties doc
v. 161	Jan 27, 2015 09:15	Lefty Leverenz	explain that backtick quotation lets table & column names be keywords (HIVE-2949, HIVE-6187)
v. 160	Jan 27, 2015 09:05	Lefty Leverenz	document use of backticks in DESCRIBE TABLE (HIVE-6187, HIVE-6013)
v. 159	Jan 13, 2015 09:19	Lefty Leverenz	mention 0.13 patch for HIVE-7971 in Change Column Name/Type/etc.
v. 158	Jan 06, 2015 08:42	Szehon Ho	Noticed that stored as parquet syntax is mentioned in the text, but missing in official DDL statement. Adding it.
v. 157	Dec 11, 2014 10:57	Lefty Leverenz	add Beeline to Show Conf section
v. 156	Dec 10, 2014 09:23	Lefty Leverenz	change version for DESCRIBE SCHEMA to 0.15 (HIVE-8803)
v. 155	Dec 09, 2014 08:43	Lefty Leverenz	add version information for alter table NO_DROP and OFFLINE (HIVE-1413 and HIVE-2605)
v. 154	Dec 09, 2014 07:36	Lefty Leverenz	minor edits for Change Column and Add/Replace Columns (HIVE-8839)
v. 153	Nov 27, 2014 09:48	Szehon Ho	add some doc about NO_DROP CASCADE
v. 152	Nov 27, 2014 06:26	Szehon Ho	Remove a redundant added sentence.
v. 151	Nov 27, 2014 01:19	Szehon Ho	Reorganizing the documentation of alter-column section for better organization, as it was getting a bit confusing with all the new information of cascade/partition specs. This should hopefully be cleaner, but feel free to edit if its not.
v. 150	Nov 22, 2014 21:54	Chaoyu Tang
v. 149	Nov 14, 2014 08:10	Lefty Leverenz	explain in Show Conf section that "set" gives the current value (but what about Beeline?)
v. 148	Nov 14, 2014 01:35	Lefty Leverenz	change jira link & version for SHOW CONF, add link to Configuration Properties
v. 147	Nov 12, 2014 05:51	Navis Ryu
v. 146	Nov 10, 2014 05:32	Lefty Leverenz	fix line spacing for DESCRIBE SCHEMA (HIVE-6601 & HIVE-8803)
v. 145	Nov 10, 2014 03:24	Lefty Leverenz	edit SCHEMA documentation for HIVE-6601 (thanks, Navis)
v. 144	Nov 10, 2014 02:34	Navis Ryu
v. 143	Oct 24, 2014 05:00	Lefty Leverenz	revise "Row Format, Storage Format, and SerDe" section and CREATE TABLE syntax comments
v. 142	Oct 23, 2014 18:41	Lars Francke	Formatting
v. 141	Oct 17, 2014 22:31	Jason Dere
v. 140	Oct 17, 2014 06:00	Lefty Leverenz	add a link, standardize partition_spec, edit partition_col
v. 139	Oct 12, 2014 03:16	Lefty Leverenz	change no_auto_compaction to uppercase (HIVE-8308)
v. 138	Oct 11, 2014 07:07	Lefty Leverenz	add versions to Display Column Statistics, minor edits
v. 137	Oct 07, 2014 23:14	Prasanth J
v. 136	Oct 07, 2014 22:30	Prasanth J
v. 135	Oct 04, 2014 23:45	Lefty Leverenz	fix line breaks in change column example (fixed the example in previous edit), add text for change column [partition]
v. 134	Oct 04, 2014 23:03	Lefty Leverenz	add "-- " to syntax comments, give version & jira for alter column [partition], add semicolons & line breaks to syntax, minor edits
v. 133	Oct 04, 2014 07:18	Lefty Leverenz	still more table properties: last_modified_user, last_modified_time (found in alter section)
v. 132	Oct 04, 2014 07:10	Lefty Leverenz	add more table properties: transactional, no_auto_compaction, comment
v. 131	Sep 30, 2014 23:03	Jason Dere
v. 130	Sep 29, 2014 21:18	Jason Dere
v. 129	Sep 29, 2014 21:15	Jason Dere
v. 128	Sep 23, 2014 18:41	Thejas Nair	fix syntax description- DESCRIBE DATABASE [EXTENDED]
v. 127	Sep 02, 2014 05:10	Lefty Leverenz	fix links to Hive Default Authorization - Legacy Mode (now in separate wiki)
v. 126	Aug 29, 2014 23:25	Jason Dere
v. 125	Aug 16, 2014 15:06	Lefty Leverenz	add links to Hive Transactions doc
v. 124	Aug 16, 2014 12:16	Lefty Leverenz	add STORED AS ORC in "Row Format, Storage Format, and SerDe"
v. 123	Aug 15, 2014 08:15	Lefty Leverenz	add link to HIVE-7446 for adding columns in 0.14.0 (thanks, Ashish Kumar Singh)
v. 122	Aug 15, 2014 03:40	Lefty Leverenz	add more SerDe links, revise "Add SerDe Properties"
v. 121	Aug 14, 2014 16:08	Ashish Singh
v. 120	Aug 12, 2014 07:10	Lefty Leverenz	add STORED AS AVRO for 0.14.0 (HIVE-6806)
v. 119	Aug 12, 2014 07:00	Lefty Leverenz	in create table syntax, add version note for TEMPORARY and add line break for SKEWED BY clause
v. 118	Aug 02, 2014 21:26	Lefty Leverenz	replace "DOT" with "." in Describe Table/View/Column syntax (thanks, Thejas)
v. 117	Jul 23, 2014 04:00	Lefty Leverenz	two links to hive.support.quoted.identifiers (HIVE-6013)
v. 116	Jul 20, 2014 07:14	Lefty Leverenz	document Hive 0.10.0 bug fix for db_name.table_name in DESCRIBE (HIVE-1977)
v. 115	Jul 20, 2014 06:54	Lefty Leverenz	add [EXTENDED] clause to DESCRIBE DATABASE (HIVE-1836, release 0.7)
v. 114	Jul 19, 2014 20:19	Lefty Leverenz	add USE <db> section and note about USE in Create Table (thanks go to André Araújo)
v. 113	Jul 18, 2014 05:17	Lefty Leverenz	explain that ADD PARTITION does not load data; clarify restriction on adding multiple partitions
v. 112	Jul 09, 2014 21:20	Jason Dere
v. 111	Jul 09, 2014 21:16	Jason Dere
v. 110	Jul 07, 2014 04:27	Lefty Leverenz	minor tweak to TBLPROPERTIES description
v. 109	Jul 07, 2014 03:42	Lefty Leverenz	add information about predefined TBLPROPERTIES
v. 108	Jul 02, 2014 06:55	Lefty Leverenz	one more revision of jira links in Skewed Tables
v. 107	Jul 02, 2014 06:25	Lefty Leverenz	revise JIRA links for list bucketing in Skewed Tables
v. 106	Jun 30, 2014 05:49	Lefty Leverenz	add hive.display.partition.cols.separately for DESCRIBE TABLE (HIVE-6689)
v. 105	May 13, 2014 05:31	Lefty Leverenz	a few edits in Skewed Tables section
v. 104	May 12, 2014 18:29	Thejas Nair	removing schema kewyord from alter-db prop; sql std auth not needed for alter-db set owner
v. 103	May 12, 2014 09:06	Lefty Leverenz	fix links to SQL standard based authorization commands
v. 102	May 12, 2014 08:52	Lefty Leverenz	add links to SQL standard based authorization commands
v. 101	May 12, 2014 07:46	Lefty Leverenz	add ALTER DB SET OWNER (HIVE-6440), misc. edits
v. 100	Apr 28, 2014 20:49	Prasanth J
v. 99	Apr 28, 2014 20:32	Prasanth J
v. 98	Apr 28, 2014 20:30	Prasanth J
v. 97	Mar 29, 2014 08:22	Lefty Leverenz	add Alter Table/Partition Compact section for HIVE-6460
v. 96	Mar 29, 2014 07:31	Lefty Leverenz	revise Show Locks section for HIVE-6460
v. 95	Mar 29, 2014 06:06	Lefty Leverenz	case insensitivity of index names in 0.13.0 (HIVE-2752)
v. 94	Mar 27, 2014 09:38	Lefty Leverenz	add SHOW TRANSACTIONS and SHOW COMPACTIONS (HIVE-6460)
v. 93	Mar 27, 2014 09:10	Lefty Leverenz	add SHOW LOCKS and link to Locking doc
v. 92	Mar 20, 2014 06:09	Lefty Leverenz	mention CTEs in Create View section (HIVE-1180)
v. 91	Mar 20, 2014 05:03	Lefty Leverenz	mention CTEs in CTAS section (HIVE-1180)
v. 90	Mar 09, 2014 05:33	Lefty Leverenz	in Permanent Functions, change jira link from HIVE-6380 to parent HIVE-6047
v. 89	Feb 25, 2014 08:26	Lefty Leverenz	link ADD JAR/FILE to CLI doc's Hive Resources section
v. 88	Feb 25, 2014 08:08	Lefty Leverenz	add standard version info and JIRA link to Create Function & Drop Function
v. 87	Feb 24, 2014 20:22	Jason Dere
v. 86	Feb 24, 2014 20:16	Jason Dere
v. 85	Feb 22, 2014 07:27	Lefty Leverenz	links to CLI & Hive Plugins docs in Create Function section
v. 84	Feb 21, 2014 00:11	Lefty Leverenz	mention Parquet with link to Parquet wikidoc
v. 83	Jan 30, 2014 06:58	Lefty Leverenz	correct misinformation about DESCRIBE EXTENDED for HIVE-6285 and email thread
v. 82	Jan 28, 2014 10:49	Lefty Leverenz	fix a broken link
v. 81	Jan 28, 2014 10:22	Lefty Leverenz	add link to Exchange Partition doc (which will be moved here eventually)
v. 80	Jan 27, 2014 12:16	Lefty Leverenz	explain why numRows can be zero in DESCRIBE EXTENDED (HIVE-6285 & user@hive email)
v. 79	Jan 26, 2014 08:28	Lefty Leverenz	replace <strong> with asterisk in two wildcard SHOW statements; minor edits
v. 78	Jan 25, 2014 10:23	Lefty Leverenz
v. 77	Jan 25, 2014 08:08	Lefty Leverenz
v. 76	Jan 17, 2014 01:07	Lefty Leverenz	fix typo in GRANT/REVOKE ROLE links
v. 75	Jan 17, 2014 00:27	Lefty Leverenz	add links to Authorization doc
v. 74	Jan 14, 2014 09:50	Lefty Leverenz	case sensitivity of index names (HIVE-2752), links to index docs, ALTER INDEX
v. 73	Dec 31, 2013 00:45	Lefty Leverenz	move general information from Partitioned Tables to Create Table, link to Alter Table section
v. 72	Dec 17, 2013 04:40	Prasad Mujumdar
v. 71	Dec 05, 2013 05:59	Lefty Leverenz	Migrated to Confluence 4.0
v. 70	Dec 05, 2013 05:59	Lefty Leverenz	add db specification to SHOW PARTITIONS (HIVE-5912)
v. 69	Nov 15, 2013 01:26	Lefty Leverenz	add char to primitive_types (HIVE-5191) for 0.13.0
v. 68	Nov 14, 2013 03:19	Lefty Leverenz	add varchar to primitive_types (HIVE-5819), add links to Types docs, trivial edits
v. 67	Nov 05, 2013 20:46	Lars Francke	Document HIVE-3976
v. 66	Oct 23, 2013 08:13	Lefty Leverenz	links to SerDe docs
v. 65	Oct 18, 2013 09:00	Lefty Leverenz	add links to dynamic partition docs in new subsection of Add Partition
v. 64	Oct 02, 2013 13:02	Lars Francke	Document how to change a table comment
v. 63	Sep 28, 2013 00:09	Lefty Leverenz	add internal link from Create View to Show Create Table; camel-cap SerDe
v. 62	Sep 27, 2013 23:47	Lefty Leverenz	move Show Columns, retry broken {toc-zone}, minor edits
v. 61	Sep 27, 2013 23:14	Lefty Leverenz	add subsection Row/Storage Format & SerDe, move LIKE and EXTERNAL paragraphs, retry broken {toc-zone}s
v. 60	Sep 27, 2013 22:48	Lefty Leverenz	revise toc and section names
v. 59	Sep 27, 2013 12:51	Lefty Leverenz	tweak section names, move Create/Drop Index, add internal link
v. 58	Sep 27, 2013 12:32	Lefty Leverenz	reorganize subsections & {toc-zone}
v. 57	Sep 27, 2013 11:33	Lefty Leverenz	try {toc-zone} again, restore escape chars, fix escape char ' ' -> '\'
v. 56	Sep 27, 2013 11:31	Lefty Leverenz	try {toc-zone} again, restore escape chars, fix escape char ' ' -> '\'
v. 55	Sep 27, 2013 11:08	Lefty Leverenz	add some h4. headings (like old xml docs), reorganize text, change toc, misc. edits
v. 54	Sep 26, 2013 21:05	Lefty Leverenz	add section for link to HCat & WebHCat DDL
v. 53	Sep 26, 2013 10:10	Lefty Leverenz	add overview and links to HCat & WebHCat DDL; add PARTITION keyword to DESCRIBE syntax; misc. edits
v. 52	Sep 11, 2013 00:54	Navis Ryu
v. 51	Aug 24, 2013 10:20	Lars Francke
v. 50	Aug 24, 2013 10:18	Lars Francke	Extended show tables form
v. 49	Aug 24, 2013 10:11	Lars Francke	document Alter Database
v. 48	Jul 30, 2013 21:58	Lefty Leverenz	add link to LZO wiki (thanks, Sanjay)
v. 47	Jul 30, 2013 20:10	Lefty Leverenz	add LZO input/output formats to STORED AS (thanks, Sanjay Subramanian)
v. 46	Jun 14, 2013 12:29	Nicolas Lalevée
v. 45	Jun 09, 2013 16:33	Thejas Nair	Updating Create table doc, with escaping info (HIVE-136)
v. 44	May 15, 2013 15:18	Siyang Chen
v. 43	Apr 10, 2013 16:39	Owen O'Malley
v. 42	Feb 01, 2013 17:30	Mark Grover
v. 41	Jan 02, 2013 02:38	Navis Ryu
v. 40	Jan 02, 2013 02:28	Navis Ryu
v. 39	Dec 25, 2012 17:48	Unknown User (zhenxiao)
v. 38	Dec 18, 2012 11:21	Unknown User (andrew.chalfant@gmail.com)
v. 37	Dec 18, 2012 11:19	Unknown User (andrew.chalfant@gmail.com)
v. 36	Dec 18, 2012 11:18	Unknown User (andrew.chalfant@gmail.com)
v. 35	Nov 07, 2012 01:27	Mark Grover
v. 34	Nov 07, 2012 01:25	Mark Grover
v. 33	Oct 16, 2012 14:15	lufeng
v. 32	Sep 11, 2012 17:54	Steven Wong
v. 31	Sep 11, 2012 17:49	Steven Wong
v. 30	Sep 03, 2012 05:16	Lars Francke	Document list bucketing
v. 29	Aug 06, 2012 04:15	Lars Francke	formatting
v. 28	Aug 06, 2012 04:14	Lars Francke	Document HIVE-2909
v. 27	Jun 26, 2012 17:43	Lars Francke
v. 26	Jun 26, 2012 16:28	Lars Francke
v. 25	Jun 21, 2012 17:52	Kevin Wilfong
v. 24	Jun 21, 2012 17:41	Kevin Wilfong
v. 23	Jun 12, 2012 19:11	Lars Francke	add stub for uniontype
v. 22	Jun 12, 2012 18:29	Lars Francke	Add TIMESTAMP data type + a few links etc.
v. 21	May 31, 2012 13:14	Lars Francke	Document SHOW TBLPROPERTIES
v. 20	Dec 15, 2011 11:32	Unknown User (gregdingle)
v. 19	Dec 15, 2011 11:30	Unknown User (gregdingle)
v. 18	Nov 27, 2011 16:15	Unknown User (akramer@fb.com)
v. 17	Oct 17, 2011 14:12	Kevin Wilfong
v. 16	Oct 17, 2011 14:04	Kevin Wilfong
v. 15	Sep 27, 2011 18:01	John Sichi
v. 14	Sep 27, 2011 17:57	John Sichi
v. 13	Aug 19, 2011 20:48	Jakob Homan	Adding documentation for describe database
v. 12	Aug 18, 2011 21:37	Carl Steinbach
v. 11	Aug 18, 2011 21:33	Carl Steinbach
v. 10	Aug 14, 2011 15:34	John Sichi
v. 9	Aug 08, 2011 15:14	Travis Powell	fixed links
v. 8	Jul 21, 2011 15:15	Charles Chen	CREATE TABLE LIKE view
v. 7	Jul 19, 2011 18:18	Carl Steinbach
v. 6	Jul 19, 2011 18:11	Carl Steinbach
v. 5	Jul 18, 2011 16:40	Unknown User (ruakh)	fix syntax of level-one header
v. 4	Jul 06, 2011 19:13	Unknown User (gregdingle)
v. 3	Jun 29, 2011 19:25	Ashoat Tevosyan
v. 2	Jun 29, 2011 19:19	Ashoat Tevosyan
v. 1	Jun 24, 2011 22:24	Confluence Administrator

Return to Page Information

Space shortcuts

Child pages