[ https://issues.apache.org/jira/browse/FLINK-8863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16518854#comment-16518854 ]
ASF GitHub Bot commented on FLINK-8863: --------------------------------------- Github user xccui commented on a diff in the pull request: https://github.com/apache/flink/pull/6090#discussion_r196998269 --- Diff: flink-libraries/flink-table/src/main/scala/org/apache/flink/table/descriptors/PrimitiveTypeValidator.scala --- @@ -0,0 +1,72 @@ +/* + * 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.descriptors + +import org.apache.flink.api.common.typeinfo.BasicTypeInfo +import org.apache.flink.table.api.TableException +import org.apache.flink.table.descriptors.PrimitiveTypeValidator.PRIMITIVE_VALUE +import scala.collection.JavaConversions._ + +/** + * Validator for [[PrimitiveTypeDescriptor]]. + */ +class PrimitiveTypeValidator extends HierarchyDescriptorValidator { + override def validateWithPrefix(keyPrefix: String, properties: DescriptorProperties): Unit = { + properties + .validateType(s"$keyPrefix${PrimitiveTypeValidator.PRIMITIVE_TYPE}", isOptional = false) + properties + .validateString(s"$keyPrefix${PrimitiveTypeValidator.PRIMITIVE_VALUE}", isOptional = false, 1) + } +} + +object PrimitiveTypeValidator { + val PRIMITIVE_TYPE = "type" + val PRIMITIVE_VALUE = "value" + + def derivePrimitiveValue(keyPrefix: String, properties: DescriptorProperties): Any = { + val typeInfo = + properties.getType(s"$keyPrefix$PRIMITIVE_TYPE") + val valueKey = s"$keyPrefix$PRIMITIVE_VALUE" + val value = typeInfo match { + case basicType: BasicTypeInfo[_] => + basicType match { + case BasicTypeInfo.INT_TYPE_INFO => + properties.getInt(valueKey) + case BasicTypeInfo.LONG_TYPE_INFO => + properties.getLong(valueKey) + case BasicTypeInfo.DOUBLE_TYPE_INFO => + properties.getDouble(valueKey) + case BasicTypeInfo.STRING_TYPE_INFO => + properties.getString(valueKey) + case BasicTypeInfo.BOOLEAN_TYPE_INFO => + properties.getBoolean(valueKey) + //TODO add more types --- End diff -- Ah, yes. The array type was not considered. I'll think about that and add the support if it's not hard to implement. Otherwise, we could arrange it to a follow-up issue. > Add user-defined function support in SQL Client > ----------------------------------------------- > > Key: FLINK-8863 > URL: https://issues.apache.org/jira/browse/FLINK-8863 > Project: Flink > Issue Type: Sub-task > Components: Table API & SQL > Reporter: Timo Walther > Assignee: Xingcan Cui > Priority: Major > Labels: pull-request-available > > This issue is a subtask of part two "Full Embedded SQL Client" of the > implementation plan mentioned in > [FLIP-24|https://cwiki.apache.org/confluence/display/FLINK/FLIP-24+-+SQL+Client]. > > It should be possible to declare user-defined functions in the SQL client. > For now, we limit the registration to classes that implement > {{ScalarFunction}}, {{TableFunction}}, {{AggregateFunction}}. Functions that > are implemented in SQL are not part of this issue. > I would suggest to introduce a {{functions}} top-level property. The > declaration could look similar to: > {code} > functions: > - name: testFunction > from: class <-- optional, default: class > class: org.my.MyScalarFunction > constructor: <-- optional, needed for certain types of functions > - 42.0 > - class: org.my.Class <-- possibility to create objects via properties > constructor: > - 1 > - true > - false > - "whatever" > - type: INT > value: 1 > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)