metastore server with authentication

2022-10-19 Thread second_comet.yahoo.com via user
I tested with hive server 2, i able to used the built in authentication like LDAP and sql based authentication. If I don't use hive server2 and would like to have security mechanism when connect to hive metastore at port 9083, what can i do? any example of config? Thank you

external table using delta format

2022-09-24 Thread second_comet.yahoo.com via user
when execute below command in beeline or pyspark, the table metadata is stored successfully in hive metastore with below warning CREATE EXTERNAL TABLE testtable USING DELTA LOCATION 's3a://path/to/delta/delta-folder/' WARN HiveExternalCatalog: Couldn't find corresponding Hive SerDe for data so

Re: hive standalone can't find MaterializationsCacheCleanerTask

2022-09-07 Thread second_comet.yahoo.com via user
Camacho Rodriguez Date:   Tue Jun 26 11:37:27 2018 -0700     HIVE-20006: Make materializations invalidation cache work with multiple active remote metastores (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan) Best,Stamatis On Tue, Aug 30, 2022 at 4:59 AM second_comet.yahoo.com via user wrote

hive standalone can't find MaterializationsCacheCleanerTask

2022-08-29 Thread second_comet.yahoo.com via user
May i know is MaterializationsCacheCleanerTask removed since 3.1 ? I can find it iin 3.0 but for latest version of hive, i cant find it. Can advice?     metastore.task.threads.always   org.apache.hadoop.hive.metastore.events.EventCleanerTask,org.apache.hadoop.hive.metastore.Materi

Re: hive table with special character for column name

2022-07-14 Thread second_comet.yahoo.com via user
;}#yiv5242789865 ul, #yiv5242789865 ol{padding-left:20px;list-style-position:inside;} | | lpc_encode | | lpc_enc...@aliyun.com | Replied Message | From | second_comet.yahoo.com via user | | Date | 7/14/2022 13:50 | | To | User | | Subject | hive table

hive table with special character for column name

2022-07-13 Thread second_comet.yahoo.com via user
I able to create hive table with special character ^ in column name    . example column name : column^test  . but when I do  select * from the table, i get below error Error: java.io.IOException: java.lang.IllegalArgumentException: Error: name expected at the position 40 of 'struct<$timestamp:s