#
# 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.
#

## Kyuubi Configurations

#
# kyuubi.authentication                    NONE
#
#kyuubi.frontend.bind.host                0.0.0.0
kyuubi.frontend.connection.url.use.hostname false
kyuubi.frontend.protocols                THRIFT_BINARY,REST
kyuubi.frontend.thrift.binary.bind.port  10009
#
# kyuubi.engine.type                       SPARK_SQL
# kyuubi.engine.share.level                USER
# kyuubi.session.engine.initialize.timeout PT3M
#
kyuubi.ha.addresses                      10.5.20.10:2181,10.5.20.11:2181,10.5.20.12:2181
kyuubi.ha.namespace                      kyuubi-tardis-testing
#

kyuubi.session.engine.idle.timeout      0

kyuubi.engine.initialize.sql      create database if not exists aloudata_project;  

#kyuubi.engine.initialize.sql      create TEMPORARY FUNCTION is_utf8 as 'com.aloudata.spark.udf.IsUtf8UDF';create TEMPORARY FUNCTION air_ilike as 'com.aloudata.spark.udf.ILikeUDF';create TEMPORARY FUNCTION regexp_split as 'com.aloudata.spark.udf.RegexpSplitUDF';create TEMPORARY FUNCTION decimal_truncate as 'com.aloudata.spark.udf.truncat.BigDecimalTruncateUDF';create TEMPORARY FUNCTION int_truncate as 'com.aloudata.spark.udf.truncat.IntTruncateUDF';create TEMPORARY FUNCTION long_truncate as 'com.aloudata.spark.udf.truncat.LongTruncateUDF';create TEMPORARY FUNCTION float_truncate as 'com.aloudata.spark.udf.truncat.FloatTruncateUDF';create TEMPORARY FUNCTION double_truncate as 'com.aloudata.spark.udf.truncat.DoubleTruncateUDF';create TEMPORARY FUNCTION timestamp_diff as 'com.aloudata.spark.udf.TimestampDiffUDF';create TEMPORARY FUNCTION air_timestamp_add as 'com.aloudata.spark.udf.TimestampAddUDF';create TEMPORARY FUNCTION air_date_add as 'com.aloudata.spark.udf.DateAddUDF';create TEMPORARY FUNCTION to_char as 'com.aloudata.spark.udf.ToCharUDF';create TEMPORARY FUNCTION is_time as 'com.aloudata.spark.udf.IsTimeUDF';create TEMPORARY FUNCTION is_date as 'com.aloudata.spark.udf.IsDateUDF';create TEMPORARY FUNCTION isdate as 'com.aloudata.spark.udf.IsDateUDF';create TEMPORARY FUNCTION is_timestamp as 'com.aloudata.spark.udf.IsTimeStampUDF';create TEMPORARY FUNCTION presto_to_char as 'com.aloudata.spark.udf.presto.PrestoToCharUDF';create TEMPORARY FUNCTION listagg as 'com.aloudata.spark.udf.ListAggUDF'

#kyuubi.engine.session.initialize.sql      create TEMPORARY FUNCTION is_utf8 as 'com.aloudata.spark.udf.IsUtf8UDF';create TEMPORARY FUNCTION air_ilike as 'com.aloudata.spark.udf.ILikeUDF';create TEMPORARY FUNCTION regexp_split as 'com.aloudata.spark.udf.RegexpSplitUDF';create TEMPORARY FUNCTION decimal_truncate as 'com.aloudata.spark.udf.truncat.BigDecimalTruncateUDF';create TEMPORARY FUNCTION int_truncate as 'com.aloudata.spark.udf.truncat.IntTruncateUDF';create TEMPORARY FUNCTION long_truncate as 'com.aloudata.spark.udf.truncat.LongTruncateUDF';create TEMPORARY FUNCTION float_truncate as 'com.aloudata.spark.udf.truncat.FloatTruncateUDF';create TEMPORARY FUNCTION double_truncate as 'com.aloudata.spark.udf.truncat.DoubleTruncateUDF';create TEMPORARY FUNCTION timestamp_diff as 'com.aloudata.spark.udf.TimestampDiffUDF';create TEMPORARY FUNCTION air_timestamp_add as 'com.aloudata.spark.udf.TimestampAddUDF';create TEMPORARY FUNCTION air_date_add as 'com.aloudata.spark.udf.DateAddUDF';create TEMPORARY FUNCTION to_char as 'com.aloudata.spark.udf.ToCharUDF';create TEMPORARY FUNCTION is_time as 'com.aloudata.spark.udf.IsTimeUDF';create TEMPORARY FUNCTION is_date as 'com.aloudata.spark.udf.IsDateUDF';create TEMPORARY FUNCTION isdate as 'com.aloudata.spark.udf.IsDateUDF';create TEMPORARY FUNCTION is_timestamp as 'com.aloudata.spark.udf.IsTimeStampUDF';create TEMPORARY FUNCTION presto_to_char as 'com.aloudata.spark.udf.presto.PrestoToCharUDF';create TEMPORARY FUNCTION listaggas 'com.aloudata.spark.udf.ListAggUDF'