[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko updated HIVE-27980: -- Description: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA future options support --- [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. was: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA future options support --- [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Assignee: Dmitriy Fingerman >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name REWRITE DATA > future options support --- > [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction, but also supports other > table maintenance operations. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko updated HIVE-27980: -- Description: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA future options support --- [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. was: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA future --- [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Assignee: Dmitriy Fingerman >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name REWRITE DATA > future options support --- > [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction, but also supports other > table maintenance operations. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Denys Kuzmenko updated HIVE-27980: -- Description: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA future --- [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. was: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Assignee: Dmitriy Fingerman >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name REWRITE DATA > future --- > [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction, but also supports other > table maintenance operations. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-27980: -- Labels: pull-request-available (was: ) > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Priority: Major > Labels: pull-request-available > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name > REWRITE DATA [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction, but also supports other > table maintenance operations. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitriy Fingerman updated HIVE-27980: - Description: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction, but also supports other table maintenance operations. was: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction. > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Priority: Major > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name > REWRITE DATA [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction, but also supports other > table maintenance operations. > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-27980) Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax
[ https://issues.apache.org/jira/browse/HIVE-27980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitriy Fingerman updated HIVE-27980: - Description: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command is not limited to compaction. was: Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. {code:java} ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} Add support for OPTIMIZE TABLE syntax. Example: {code:java} OPTIMIZE TABLE name REWRITE DATA [USING BIN_PACK] [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] WHERE category = 'c1' {code} This syntax will be inline with Impala. Also, OPTIMIZE command supports more syntax than only compaction. > Hive Iceberg Compaction: add support for OPTIMIZE TABLE syntax > -- > > Key: HIVE-27980 > URL: https://issues.apache.org/jira/browse/HIVE-27980 > Project: Hive > Issue Type: New Feature >Reporter: Dmitriy Fingerman >Priority: Major > > Presently Hive Iceberg supports Major compaction using HIVE ACID syntax below. > {code:java} > ALTER TABLE name COMPACT MAJOR [AND WAIT] {code} > Add support for OPTIMIZE TABLE syntax. Example: > {code:java} > OPTIMIZE TABLE name > REWRITE DATA [USING BIN_PACK] > [ ( { FILE_SIZE_THRESHOLD | MIN_INPUT_FILES } = [, ... ] ) ] > WHERE category = 'c1' {code} > This syntax will be inline with Impala. > Also, OPTIMIZE command is not limited to compaction. > -- This message was sent by Atlassian Jira (v8.20.10#820010)