[ 
https://issues.apache.org/jira/browse/FLINK-6968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16398016#comment-16398016
 ] 

ASF GitHub Bot commented on FLINK-6968:
---------------------------------------

Github user xccui commented on a diff in the pull request:

    https://github.com/apache/flink/pull/5688#discussion_r174339658
  
    --- Diff: 
flink-libraries/flink-table/src/test/scala/org/apache/flink/table/runtime/stream/table/QueryableTableSinkTest.scala
 ---
    @@ -0,0 +1,102 @@
    +/*
    + * 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.runtime.stream.table
    +
    +import java.lang.{Boolean => JBool}
    +
    +import org.apache.flink.api.common.state.ValueStateDescriptor
    +import org.apache.flink.api.common.time.Time
    +import org.apache.flink.api.common.typeinfo.TypeInformation
    +import org.apache.flink.api.java.tuple.{Tuple2 => JTuple2}
    +import org.apache.flink.api.java.typeutils.RowTypeInfo
    +import org.apache.flink.streaming.api.operators.LegacyKeyedProcessOperator
    +import org.apache.flink.table.api.StreamQueryConfig
    +import org.apache.flink.table.runtime.harness.HarnessTestBase
    +import org.apache.flink.table.sinks.{QueryableStateProcessFunction, 
RowKeySelector}
    +import org.apache.flink.types.Row
    +import org.junit.Assert.assertEquals
    +import org.junit.Test
    +
    +class QueryableTableSinkTest extends HarnessTestBase {
    +  @Test
    +  def testRowSelector(): Unit = {
    +    val keyTypes = Array(TypeInformation.of(classOf[List[Int]]), 
TypeInformation.of(classOf[String]))
    +    val selector = new RowKeySelector(Array(0, 2), new 
RowTypeInfo(keyTypes:_*))
    +
    +    val src = Row.of(List(1), "a", "b")
    +    val key = selector.getKey(JTuple2.of(true, src))
    +
    +    assertEquals(Row.of(List(1), "b"), key)
    +  }
    +
    +  @Test
    +  def testProcessFunction(): Unit = {
    +    val queryConfig = new StreamQueryConfig()
    +      .withIdleStateRetentionTime(Time.milliseconds(2), 
Time.milliseconds(10))
    +
    +    val keys = Array("id")
    +    val keyType = new RowTypeInfo(TypeInformation.of(classOf[String]))
    +    val fieldNames = Array("id", "is_manager", "name")
    +    val fieldTypes: Array[TypeInformation[_]] = Array(
    +      TypeInformation.of(classOf[String]).asInstanceOf[TypeInformation[_]],
    +      TypeInformation.of(classOf[JBool]).asInstanceOf[TypeInformation[_]],
    +      TypeInformation.of(classOf[String]).asInstanceOf[TypeInformation[_]])
    +    val func = new QueryableStateProcessFunction("test", queryConfig, 
keys, fieldNames, fieldTypes)
    +
    +    val operator = new LegacyKeyedProcessOperator[Row, JTuple2[JBool, 
Row], Void](func)
    --- End diff --
    
    Try to avoid using deprecated classes/methods.


> Store streaming, updating tables with unique key in queryable state
> -------------------------------------------------------------------
>
>                 Key: FLINK-6968
>                 URL: https://issues.apache.org/jira/browse/FLINK-6968
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table API & SQL
>            Reporter: Fabian Hueske
>            Assignee: Renjie Liu
>            Priority: Major
>
> Streaming tables with unique key are continuously updated. For example 
> queries with a non-windowed aggregation generate such tables. Commonly, such 
> updating tables are emitted via an upsert table sink to an external datastore 
> (k-v store, database) to make it accessible to applications.
> This issue is about adding a feature to store and maintain such a table as 
> queryable state in Flink. By storing the table in Flnk's queryable state, we 
> do not need an external data store to access the results of the query but can 
> query the results directly from Flink.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to