You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by ja...@apache.org on 2019/07/02 09:18:49 UTC
[flink] branch master updated (a6d72fe -> c3f2ad8)
This is an automated email from the ASF dual-hosted git repository.
jark pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git.
from a6d72fe [FLINK-12937][table-planner-blink] Introduce join reorder planner rules in blink planner
new 6e48056 [FLINK-12805][table-api] Introduce PartitionableTableSource for partition pruning
new fb111ef [FLINK-12808][table-api] Introduce OverwritableTableSink for supporting insert overwrite
new c3f2ad8 [FLINK-12809][table-api] Introduce PartitionableTableSink for supporting writing data into partitions
The 3 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../flink/table/sinks/OverwritableTableSink.java} | 21 ++--
.../flink/table/sinks/PartitionableTableSink.java | 112 +++++++++++++++++++++
.../table/sources/PartitionableTableSource.java | 68 +++++++++++++
3 files changed, 191 insertions(+), 10 deletions(-)
copy flink-table/{flink-table-api-java-bridge/src/main/java/org/apache/flink/table/sinks/BatchTableSink.java => flink-table-common/src/main/java/org/apache/flink/table/sinks/OverwritableTableSink.java} (65%)
create mode 100644 flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/PartitionableTableSink.java
create mode 100644 flink-table/flink-table-common/src/main/java/org/apache/flink/table/sources/PartitionableTableSource.java
[flink] 03/03: [FLINK-12809][table-api] Introduce
PartitionableTableSink for supporting writing data into partitions
Posted by ja...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jark pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
commit c3f2ad8c8c10097dc7f680ccdf2e9b99babc349c
Author: 云邪 <wu...@alibaba-inc.com>
AuthorDate: Wed Jun 12 11:01:40 2019 +0800
[FLINK-12809][table-api] Introduce PartitionableTableSink for supporting writing data into partitions
---
.../flink/table/sinks/PartitionableTableSink.java | 112 +++++++++++++++++++++
1 file changed, 112 insertions(+)
diff --git a/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/PartitionableTableSink.java b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/PartitionableTableSink.java
new file mode 100644
index 0000000..5e7c26c
--- /dev/null
+++ b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/PartitionableTableSink.java
@@ -0,0 +1,112 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.sinks;
+
+import org.apache.flink.annotation.Experimental;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * An interface for partitionable {@link TableSink}. A partitionable sink can writes
+ * query results to partitions.
+ *
+ * <p>Partition columns are defined via {@link #getPartitionFieldNames()} and the field names
+ * should be sorted in a strict order. And all the partition fields should exist in the
+ * {@link TableSink#getTableSchema()}.
+ *
+ * <p>For example, a partitioned table named {@code my_table} with a table schema
+ * {@code [a INT, b VARCHAR, c DOUBLE, dt VARCHAR, country VARCHAR]} is partitioned on columns
+ * {@code dt, country}. Then {@code dt} is the first partition column, and
+ * {@code country} is the secondary partition column.
+ *
+ * <p>We can insert data into table partitions using INSERT INTO PARTITION syntax, for example:
+ * <pre>
+ * <code>
+ * INSERT INTO my_table PARTITION (dt='2019-06-20', country='bar') select a, b, c from my_view
+ * </code>
+ * </pre>
+ * When all the partition columns are set a value in PARTITION clause, it is inserting into a
+ * static partition. It will writes the query result into a static partition,
+ * i.e. {@code dt='2019-06-20', country='bar'}. The user specified static partitions will be told
+ * to the sink via {@link #setStaticPartition(Map)}.
+ *
+ * <p>The INSERT INTO PARTITION syntax also supports dynamic partition inserts.
+ * <pre>
+ * <code>
+ * INSERT INTO my_table PARTITION (dt='2019-06-20') select a, b, c, country from another_view
+ * </code>
+ * </pre>
+ * When partial partition columns (prefix part of all partition columns) are set a value in
+ * PARTITION clause, it is writing the query result into a dynamic partition. In the above example,
+ * the static partition part is {@code dt='2019-06-20'} which will be told to the sink via
+ * {@link #setStaticPartition(Map)}. And the {@code country} is the dynamic partition which will be
+ * get from each record.
+ */
+@Experimental
+public interface PartitionableTableSink {
+
+ /**
+ * Gets the partition field names of the table. The partition field names should be sorted in
+ * a strict order, i.e. they have the order as specified in the PARTITION statement in DDL.
+ * This should be an empty set if the table is not partitioned.
+ *
+ * <p>All the partition fields should exist in the {@link TableSink#getTableSchema()}.
+ *
+ * @return partition field names of the table, empty if the table is not partitioned.
+ */
+ List<String> getPartitionFieldNames();
+
+ /**
+ * Sets the static partition into the {@link TableSink}. The static partition may be partial
+ * of all partition columns. See the class Javadoc for more details.
+ *
+ * <p>The static partition is represented as a {@code Map<String, String>} which maps from
+ * partition field name to partition value. The partition values are all encoded as strings,
+ * i.e. encoded using String.valueOf(...). For example, if we have a static partition
+ * {@code f0=1024, f1="foo", f2="bar"}. f0 is an integer type, f1 and f2 are string types.
+ * They will all be encoded as strings: "1024", "foo", "bar". And can be decoded to original
+ * literals based on the field types.
+ *
+ * @param partitions user specified static partition
+ */
+ void setStaticPartition(Map<String, String> partitions);
+
+ /**
+ * If returns true, sink can trust all records will definitely be grouped by partition fields
+ * before consumed by the {@link TableSink}, i.e. the sink will receive all elements of one
+ * partition and then all elements of another partition, elements of different partitions
+ * will not be mixed. For some sinks, this can be used to reduce number of the partition
+ * writers to improve writing performance.
+ *
+ * <p>This method is used to configure the behavior of input whether to be grouped by partition,
+ * if true, at the same time the sink should also configure itself, i.e. set an internal field
+ * that changes the writing behavior (writing one partition at a time).
+ *
+ * @param supportsGrouping whether the execution mode supports grouping,
+ * e.g. grouping (usually use sort to implement) is only supported
+ * in batch mode, not supported in streaming mode.
+ *
+ * @return whether data need to be grouped by partition before consumed by the sink. Default is false.
+ * If {@code supportsGrouping} is false, it should never return true (requires grouping), otherwise it will fail.
+ */
+ default boolean configurePartitionGrouping(boolean supportsGrouping) {
+ return false;
+ }
+}
[flink] 01/03: [FLINK-12805][table-api] Introduce
PartitionableTableSource for partition pruning
Posted by ja...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jark pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
commit 6e4805673739fa1f8e85389d38ef6f3de20fc005
Author: 云邪 <wu...@alibaba-inc.com>
AuthorDate: Wed Jun 12 11:01:01 2019 +0800
[FLINK-12805][table-api] Introduce PartitionableTableSource for partition pruning
---
.../table/sources/PartitionableTableSource.java | 68 ++++++++++++++++++++++
1 file changed, 68 insertions(+)
diff --git a/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sources/PartitionableTableSource.java b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sources/PartitionableTableSource.java
new file mode 100644
index 0000000..591ec50
--- /dev/null
+++ b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sources/PartitionableTableSource.java
@@ -0,0 +1,68 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.sources;
+
+import org.apache.flink.annotation.Experimental;
+import org.apache.flink.table.sinks.TableSink;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+ * An interface for partitionable {@link TableSource}.
+ *
+ * <p>A {@link PartitionableTableSource} can exclude partitions from reading, which
+ * includes skipping the metadata. This is especially useful when there are thousands
+ * of partitions in a table.
+ *
+ * <p>A partition is represented as a {@code Map<String, String>} which maps from partition
+ * field name to partition value. Since the map is NOT ordered, the correct order of partition
+ * fields should be obtained via {@link #getPartitionFieldNames()}.
+ */
+@Experimental
+public interface PartitionableTableSource {
+
+ /**
+ * Returns all the partitions of this {@link PartitionableTableSource}.
+ */
+ List<Map<String, String>> getPartitions();
+
+ /**
+ * Gets the partition field names of the table. The partition field names should be sorted in
+ * a strict order, i.e. they have the order as specified in the PARTITION statement in DDL.
+ * This should be an empty set if the table is not partitioned.
+ *
+ * <p>All the partition fields should exist in the {@link TableSink#getTableSchema()}.
+ *
+ * @return partition field names of the table, empty if the table is not partitioned.
+ */
+ List<String> getPartitionFieldNames();
+
+ /**
+ * Applies the remaining partitions to the table source. The {@code remainingPartitions} is
+ * the remaining partitions of {@link #getPartitions()} after partition pruning applied.
+ *
+ * <p>After trying to apply partition pruning, we should return a new {@link TableSource}
+ * instance which holds all pruned-partitions.
+ *
+ * @param remainingPartitions Remaining partitions after partition pruning applied.
+ * @return A new cloned instance of {@link TableSource} holds all pruned-partitions.
+ */
+ TableSource applyPartitionPruning(List<Map<String, String>> remainingPartitions);
+}
[flink] 02/03: [FLINK-12808][table-api] Introduce
OverwritableTableSink for supporting insert overwrite
Posted by ja...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jark pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/flink.git
commit fb111ef22b8f87dd25e61160678fc8857dffcfe0
Author: 云邪 <wu...@alibaba-inc.com>
AuthorDate: Wed Jun 12 11:01:20 2019 +0800
[FLINK-12808][table-api] Introduce OverwritableTableSink for supporting insert overwrite
---
.../flink/table/sinks/OverwritableTableSink.java | 36 ++++++++++++++++++++++
1 file changed, 36 insertions(+)
diff --git a/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/OverwritableTableSink.java b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/OverwritableTableSink.java
new file mode 100644
index 0000000..6b46ef2
--- /dev/null
+++ b/flink-table/flink-table-common/src/main/java/org/apache/flink/table/sinks/OverwritableTableSink.java
@@ -0,0 +1,36 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.flink.table.sinks;
+
+import org.apache.flink.annotation.Experimental;
+
+/**
+ * A {@link TableSink} that supports INSERT OVERWRITE should implement this trait.
+ * INSERT OVERWRITE will overwrite any existing data in the table or partition.
+ *
+ * @see PartitionableTableSink for the definition of partition.
+ */
+@Experimental
+public interface OverwritableTableSink {
+
+ /**
+ * Configures whether the insert should overwrite existing data or not.
+ */
+ void setOverwrite(boolean overwrite);
+}