Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

column statistics on [demo.hudi_dimcustomer] missing? #319

Open
alberttwong opened this issue Feb 3, 2024 · 4 comments
Open

column statistics on [demo.hudi_dimcustomer] missing? #319

alberttwong opened this issue Feb 3, 2024 · 4 comments

Comments

@alberttwong
Copy link
Contributor

alberttwong commented Feb 3, 2024 •
edited

Following https://onetable.dev/docs/demo/docker/ with PR #320

Trying to query from starrocks

StarRocks > CREATE EXTERNAL CATALOG hudi_catalog_hms
    -> PROPERTIES
    -> (
    ->     "type" = "hudi",
    ->     "hive.metastore.type" = "hive",
    ->     "hive.metastore.uris" = "thrift://hive-metastore:9083",
    ->     "aws.s3.use_instance_profile" = "false",
    ->     "aws.s3.access_key" = "admin",
    ->     "aws.s3.secret_key" = "password",
    ->     "aws.s3.region" = "us-east-1",
    ->     "aws.s3.enable_ssl" = "false",
    ->     "aws.s3.enable_path_style_access" = "true",
    ->     "aws.s3.endpoint" = "http://minio:9000"
    -> );
Query OK, 0 rows affected (0.32 sec)

StarRocks > set catalog hudi_catalog_hms;
Query OK, 0 rows affected (0.00 sec)

StarRocks > show databases;
+--------------------+
| Database           |
+--------------------+
| default            |
| demo               |
| information_schema |
+--------------------+
3 rows in set (0.47 sec)

StarRocks > use demo
;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
StarRocks > use demo;
Database changed
StarRocks > show tables;
+------------------+
| Tables_in_demo   |
+------------------+
| hudi_dimcustomer |
+------------------+
1 row in set (0.05 sec)

StarRocks > select * from hudi_dimcustomer;
Empty set (1.86 sec)

2024-02-03 16:34:30,972 INFO (starrocks-mysql-nio-pool-1|185) [HiveMetaStoreClient.openInternal():459] Trying to connect to metastore with URI thrift://hive-metastore.onetable:9083
2024-02-03 16:34:30,972 INFO (starrocks-mysql-nio-pool-1|185) [HiveMetaStoreClient.openInternal():539] Opened a connection to metastore, current connections: 1
2024-02-03 16:34:30,976 INFO (starrocks-mysql-nio-pool-1|185) [HiveMetaStoreClient.openInternal():597] Connected to metastore.
2024-02-03 16:34:30,979 ERROR (starrocks-mysql-nio-pool-1|185) [HiveMetaClient.callRPC():162] Failed to get table column statistics on [demo.hudi_dimcustomer]
java.lang.reflect.InvocationTargetException: null
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:160) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastoreOperations.getTableStatistics(HiveMetastoreOperations.java:250) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveStatisticsProvider.getTableStatistics(HiveStatisticsProvider.java:81) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hudi.HudiMetadata.getTableStatistics(HudiMetadata.java:161) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.CatalogConnectorMetadata.getTableStatistics(CatalogConnectorMetadata.java:133) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.lambda$getTableStatistics$6(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at java.util.Optional.map(Optional.java:265) ~[?:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:403) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeHMSTableScanNode(StatisticsCalculator.java:409) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:387) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:158) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalHiveScanOperator.accept(LogicalHiveScanOperator.java:78) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:174) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:57) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:65) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:617) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimizeByCost(Optimizer.java:208) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:138) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:150) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.planQuery(StatementPlanner.java:125) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:64) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:485) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:379) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:570) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:848) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: org.apache.thrift.TApplicationException: Required field 'engine' is unset! Struct:TableStatsRequest(dbName:demo, tblName:hudi_dimcustomer, colNames:[_c0, customerkey, geographykey, firstname, lastname, birthdate, maritalstatus, gender, yearlyincome, totalchildren, numberchildrenathome, education, occupation, houseownerflag, numbercarsowned], engine:null)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79) ~[libthrift-0.13.0.jar:0.13.0]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_statistics_req(ThriftHiveMetastore.java:4161) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_statistics_req(ThriftHiveMetastore.java:4148) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:735) ~[starrocks-fe.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:727) ~[starrocks-fe.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:208) ~[hive-apache-3.1.2-13.jar:?]
        at com.sun.proxy.$Proxy37.getTableColumnStatistics(Unknown Source) ~[?:?]
        ... 64 more
2024-02-03 16:34:30,980 ERROR (starrocks-mysql-nio-pool-1|185) [HiveMetaClient.callRPC():169] An exception occurred when using the current long link to access metastore. msg: Failed to get table column statistics on [demo.hudi_dimcustomer]
2024-02-03 16:34:30,980 INFO (starrocks-mysql-nio-pool-1|185) [HiveMetaStoreClient.close():622] Closed a connection to metastore, current connections: 0
2024-02-03 16:34:30,981 ERROR (starrocks-mysql-nio-pool-1|185) [CachingHiveMetastore.get():616] Error occurred when loading cache
com.google.common.util.concurrent.UncheckedExecutionException: com.starrocks.connector.exception.StarRocksConnectorException: Failed to get table column statistics on [demo.hudi_dimcustomer], msg: null
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2085) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastoreOperations.getTableStatistics(HiveMetastoreOperations.java:250) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveStatisticsProvider.getTableStatistics(HiveStatisticsProvider.java:81) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hudi.HudiMetadata.getTableStatistics(HudiMetadata.java:161) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.CatalogConnectorMetadata.getTableStatistics(CatalogConnectorMetadata.java:133) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.lambda$getTableStatistics$6(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at java.util.Optional.map(Optional.java:265) ~[?:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:403) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeHMSTableScanNode(StatisticsCalculator.java:409) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:387) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:158) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalHiveScanOperator.accept(LogicalHiveScanOperator.java:78) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:174) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:57) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:65) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:617) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimizeByCost(Optimizer.java:208) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:138) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:150) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.planQuery(StatementPlanner.java:125) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:64) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:485) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:379) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:570) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:848) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: com.starrocks.connector.exception.StarRocksConnectorException: Failed to get table column statistics on [demo.hudi_dimcustomer], msg: null
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:163) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 49 more
Caused by: java.lang.reflect.InvocationTargetException
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:160) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 49 more
Caused by: org.apache.thrift.TApplicationException: Required field 'engine' is unset! Struct:TableStatsRequest(dbName:demo, tblName:hudi_dimcustomer, colNames:[_c0, customerkey, geographykey, firstname, lastname, birthdate, maritalstatus, gender, yearlyincome, totalchildren, numberchildrenathome, education, occupation, houseownerflag, numbercarsowned], engine:null)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79) ~[libthrift-0.13.0.jar:0.13.0]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_statistics_req(ThriftHiveMetastore.java:4161) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_statistics_req(ThriftHiveMetastore.java:4148) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:735) ~[starrocks-fe.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:727) ~[starrocks-fe.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:208) ~[hive-apache-3.1.2-13.jar:?]
        at com.sun.proxy.$Proxy37.getTableColumnStatistics(Unknown Source) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:160) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 49 more
2024-02-03 16:34:30,981 ERROR (starrocks-mysql-nio-pool-1|185) [CachingHiveMetastore.get():616] Error occurred when loading cache
com.google.common.util.concurrent.UncheckedExecutionException: com.starrocks.connector.exception.StarRocksConnectorException: Failed to get table column statistics on [demo.hudi_dimcustomer], msg: null
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2085) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastoreOperations.getTableStatistics(HiveMetastoreOperations.java:250) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveStatisticsProvider.getTableStatistics(HiveStatisticsProvider.java:81) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hudi.HudiMetadata.getTableStatistics(HudiMetadata.java:161) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.CatalogConnectorMetadata.getTableStatistics(CatalogConnectorMetadata.java:133) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.lambda$getTableStatistics$6(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at java.util.Optional.map(Optional.java:265) ~[?:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:389) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.getTableStatistics(MetadataMgr.java:403) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeHMSTableScanNode(StatisticsCalculator.java:409) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:387) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalHiveScan(StatisticsCalculator.java:158) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalHiveScanOperator.accept(LogicalHiveScanOperator.java:78) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:174) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:57) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:65) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:617) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimizeByCost(Optimizer.java:208) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:138) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:150) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.planQuery(StatementPlanner.java:125) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:64) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:485) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:379) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:570) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:848) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: com.starrocks.connector.exception.StarRocksConnectorException: Failed to get table column statistics on [demo.hudi_dimcustomer], msg: null
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:163) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 36 more
Caused by: java.lang.reflect.InvocationTargetException
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:160) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 36 more
Caused by: org.apache.thrift.TApplicationException: Required field 'engine' is unset! Struct:TableStatsRequest(dbName:demo, tblName:hudi_dimcustomer, colNames:[_c0, customerkey, geographykey, firstname, lastname, birthdate, maritalstatus, gender, yearlyincome, totalchildren, numberchildrenathome, education, occupation, houseownerflag, numbercarsowned], engine:null)
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79) ~[libthrift-0.13.0.jar:0.13.0]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_statistics_req(ThriftHiveMetastore.java:4161) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_statistics_req(ThriftHiveMetastore.java:4148) ~[hive-apache-3.1.2-13.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:735) ~[starrocks-fe.jar:?]
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTableColumnStatistics(HiveMetaStoreClient.java:727) ~[starrocks-fe.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:208) ~[hive-apache-3.1.2-13.jar:?]
        at com.sun.proxy.$Proxy37.getTableColumnStatistics(Unknown Source) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:160) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.callRPC(HiveMetaClient.java:149) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetaClient.getTableColumnStats(HiveMetaClient.java:328) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.HiveMetastore.getTableStatistics(HiveMetastore.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:4011) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4034) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:5010) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:5017) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.get(CachingHiveMetastore.java:614) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.getTableStatistics(CachingHiveMetastore.java:367) ~[starrocks-fe.jar:?]
        at com.starrocks.connector.hive.CachingHiveMetastore.loadTableStatistics(CachingHiveMetastore.java:371) ~[starrocks-fe.jar:?]
        at com.google.common.cache.CacheLoader$FunctionToCacheLoader.load(CacheLoader.java:169) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.CacheLoader$1.load(CacheLoader.java:192) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3570) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2312) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2189) ~[spark-dpp-1.0.0.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2079) ~[spark-dpp-1.0.0.jar:?]
        ... 36 more
2024-02-03 16:34:30,982 WARN (starrocks-mysql-nio-pool-1|185) [HudiMetadata.getTableStatistics():168] Failed to get table column statistics on [HiveTable{catalogName='hudi_catalog_hms', hiveDbName='demo', hiveTableName='hudi_dimcustomer', resourceName='hudi_catalog_hms', id=100000002, name='hudi_dimcustomer', type=HIVE, createTime=1706976916}]. error : com.starrocks.connector.exception.StarRocksConnectorException: Failed to get table column statistics on [demo.hudi_dimcustomer], msg: null
2024-02-03 16:34:30,983 INFO (starrocks-mysql-nio-pool-1|185) [MetadataMgr.removeQueryMetadata():172] Succeed to deregister query level connector metadata on query id: Optional[1a724edc-c2b2-11ee-b2b8-0242ac150005]
@alberttwong
Copy link
Contributor Author 

StarRocks > select * from columns;
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
| TABLE_CATALOG | TABLE_SCHEMA       | TABLE_NAME              | COLUMN_NAME                   | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE      | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | COLUMN_SIZE | DECIMAL_DIGITS | GENERATION_EXPRESSION | SRS_ID |
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
| NULL          | demo               | hudi_dimcustomer        | _c0                           |                1 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | customerkey                   |                2 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | geographykey                  |                3 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | firstname                     |                4 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | lastname                      |                5 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | birthdate                     |                6 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | maritalstatus                 |                7 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | gender                        |                8 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | yearlyincome                  |                9 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | totalchildren                 |               10 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | numberchildrenathome          |               11 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | education                     |               12 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | occupation                    |               13 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | houseownerflag                |               14 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | demo               | hudi_dimcustomer        | numbercarsowned               |               15 | NULL           | YES         | varchar   |                  1048576 |                3145728 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1048576) |            |       |            |                |     1048576 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_CATALOG                 |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_SCHEMA                  |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_NAME                    |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_TYPE                    |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | ENGINE                        |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | VERSION                       |                6 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | ROW_FORMAT                    |                7 | NULL           | YES         | varchar   |                       10 |                     30 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(10)      |            |       |            |                |          10 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_ROWS                    |                8 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | AVG_ROW_LENGTH                |                9 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | DATA_LENGTH                   |               10 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | MAX_DATA_LENGTH               |               11 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | INDEX_LENGTH                  |               12 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | DATA_FREE                     |               13 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | AUTO_INCREMENT                |               14 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | CREATE_TIME                   |               15 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | UPDATE_TIME                   |               16 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | CHECK_TIME                    |               17 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_COLLATION               |               18 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | CHECKSUM                      |               19 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | tables                  | CREATE_OPTIONS                |               20 | NULL           | YES         | varchar   |                      255 |                    765 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(255)     |            |       |            |                |         255 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | tables                  | TABLE_COMMENT                 |               21 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | GRANTEE                       |                1 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | TABLE_CATALOG                 |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | TABLE_SCHEMA                  |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | TABLE_NAME                    |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | PRIVILEGE_TYPE                |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_privileges        | IS_GRANTABLE                  |                6 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | CONSTRAINT_CATALOG            |                1 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | CONSTRAINT_SCHEMA             |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | CONSTRAINT_NAME               |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | UNIQUE_CONSTRAINT_CATALOG     |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | UNIQUE_CONSTRAINT_SCHEMA      |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | UNIQUE_CONSTRAINT_NAME        |                6 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | MATCH_OPTION                  |                7 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | UPDATE_RULE                   |                8 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | DELETE_RULE                   |                9 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | TABLE_NAME                    |               10 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | referential_constraints | REFERENCED_TABLE_NAME         |               11 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | CONSTRAINT_CATALOG            |                1 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | CONSTRAINT_SCHEMA             |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | CONSTRAINT_NAME               |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | TABLE_CATALOG                 |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | TABLE_SCHEMA                  |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | TABLE_NAME                    |                6 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | COLUMN_NAME                   |                7 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | ORDINAL_POSITION              |                8 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | POSITION_IN_UNIQUE_CONSTRAINT |                9 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | REFERENCED_TABLE_SCHEMA       |               10 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | REFERENCED_TABLE_NAME         |               11 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | key_column_usage        | REFERENCED_COLUMN_NAME        |               12 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | SPECIFIC_NAME                 |                1 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_CATALOG               |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_SCHEMA                |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_NAME                  |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_TYPE                  |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | DTD_IDENTIFIER                |                6 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_BODY                  |                7 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_DEFINITION            |                8 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | EXTERNAL_NAME                 |                9 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | EXTERNAL_LANGUAGE             |               10 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | PARAMETER_STYLE               |               11 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | IS_DETERMINISTIC              |               12 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | SQL_DATA_ACCESS               |               13 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | SQL_PATH                      |               14 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | SECURITY_TYPE                 |               15 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | CREATED                       |               16 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | LAST_ALTERED                  |               17 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | SQL_MODE                      |               18 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | ROUTINE_COMMENT               |               19 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | DEFINER                       |               20 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | CHARACTER_SET_CLIENT          |               21 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | COLLATION_CONNECTION          |               22 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | routines                | DATABASE_COLLATION            |               23 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schemata                | CATALOG_NAME                  |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schemata                | SCHEMA_NAME                   |                2 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schemata                | DEFAULT_CHARACTER_SET_NAME    |                3 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schemata                | DEFAULT_COLLATION_NAME        |                4 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schemata                | SQL_PATH                      |                5 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | TABLE_CATALOG                 |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | TABLE_SCHEMA                  |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | TABLE_NAME                    |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_NAME                   |                4 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | ORDINAL_POSITION              |                5 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_DEFAULT                |                6 | NULL           | YES         | varchar   |                     1024 |                   3072 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1024)    |            |       |            |                |        1024 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | IS_NULLABLE                   |                7 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | DATA_TYPE                     |                8 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | CHARACTER_MAXIMUM_LENGTH      |                9 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | CHARACTER_OCTET_LENGTH        |               10 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | NUMERIC_PRECISION             |               11 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | NUMERIC_SCALE                 |               12 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | DATETIME_PRECISION            |               13 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | CHARACTER_SET_NAME            |               14 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLLATION_NAME                |               15 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_TYPE                   |               16 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_KEY                    |               17 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | EXTRA                         |               18 | NULL           | YES         | varchar   |                       27 |                     81 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(27)      |            |       |            |                |          27 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | PRIVILEGES                    |               19 | NULL           | YES         | varchar   |                       80 |                    240 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(80)      |            |       |            |                |          80 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_COMMENT                |               20 | NULL           | YES         | varchar   |                      255 |                    765 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(255)     |            |       |            |                |         255 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | COLUMN_SIZE                   |               21 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | DECIMAL_DIGITS                |               22 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | columns                 | GENERATION_EXPRESSION         |               23 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | columns                 | SRS_ID                        |               24 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | character_sets          | CHARACTER_SET_NAME            |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | character_sets          | DEFAULT_COLLATE_NAME          |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | character_sets          | DESCRIPTION                   |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | character_sets          | MAXLEN                        |                4 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | collations              | COLLATION_NAME                |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | collations              | CHARACTER_SET_NAME            |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | collations              | ID                            |                3 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | collations              | IS_DEFAULT                    |                4 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | collations              | IS_COMPILED                   |                5 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | collations              | SORTLEN                       |                6 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | CONSTRAINT_CATALOG            |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | CONSTRAINT_SCHEMA             |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | CONSTRAINT_NAME               |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | TABLE_SCHEMA                  |                4 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | TABLE_NAME                    |                5 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | table_constraints       | CONSTRAINT_TYPE               |                6 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | ENGINE                        |                1 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | SUPPORT                       |                2 | NULL           | YES         | varchar   |                        8 |                     24 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(8)       |            |       |            |                |           8 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | COMMENT                       |                3 | NULL           | YES         | varchar   |                       80 |                    240 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(80)      |            |       |            |                |          80 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | TRANSACTIONS                  |                4 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | XA                            |                5 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | engines                 | SAVEPOINTS                    |                6 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | user_privileges         | GRANTEE                       |                1 | NULL           | YES         | varchar   |                       81 |                    243 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(81)      |            |       |            |                |          81 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | user_privileges         | TABLE_CATALOG                 |                2 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | user_privileges         | PRIVILEGE_TYPE                |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | user_privileges         | IS_GRANTABLE                  |                4 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schema_privileges       | GRANTEE                       |                1 | NULL           | YES         | varchar   |                       81 |                    243 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(81)      |            |       |            |                |          81 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schema_privileges       | TABLE_CATALOG                 |                2 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schema_privileges       | TABLE_SCHEMA                  |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schema_privileges       | PRIVILEGE_TYPE                |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | schema_privileges       | IS_GRANTABLE                  |                5 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | TABLE_CATALOG                 |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | TABLE_SCHEMA                  |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | TABLE_NAME                    |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | NON_UNIQUE                    |                4 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | statistics              | INDEX_SCHEMA                  |                5 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | INDEX_NAME                    |                6 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | SEQ_IN_INDEX                  |                7 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | statistics              | COLUMN_NAME                   |                8 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | COLLATION                     |                9 | NULL           | YES         | varchar   |                        1 |                      3 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1)       |            |       |            |                |           1 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | CARDINALITY                   |               10 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | statistics              | SUB_PART                      |               11 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | statistics              | PACKED                        |               12 | NULL           | YES         | varchar   |                       10 |                     30 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(10)      |            |       |            |                |          10 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | NULLABLE                      |               13 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | INDEX_TYPE                    |               14 | NULL           | YES         | varchar   |                       16 |                     48 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(16)      |            |       |            |                |          16 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | COMMENT                       |               15 | NULL           | YES         | varchar   |                       16 |                     48 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(16)      |            |       |            |                |          16 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | statistics              | INDEX_COMMENT                 |               16 | NULL           | YES         | varchar   |                     1024 |                   3072 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(1024)    |            |       |            |                |        1024 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | TRIGGER_CATALOG               |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | TRIGGER_SCHEMA                |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | TRIGGER_NAME                  |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | EVENT_MANIPULATION            |                4 | NULL           | YES         | varchar   |                        6 |                     18 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(6)       |            |       |            |                |           6 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | EVENT_OBJECT_CATALOG          |                5 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | EVENT_OBJECT_SCHEMA           |                6 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | EVENT_OBJECT_TABLE            |                7 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_ORDER                  |                8 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_CONDITION              |                9 | NULL           | YES         | varchar   |                    65535 |                 196605 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(65535)   |            |       |            |                |       65535 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_STATEMENT              |               10 | NULL           | YES         | varchar   |                    65535 |                 196605 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(65535)   |            |       |            |                |       65535 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_ORIENTATION            |               11 | NULL           | YES         | varchar   |                        9 |                     27 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(9)       |            |       |            |                |           9 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_TIMING                 |               12 | NULL           | YES         | varchar   |                        6 |                     18 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(6)       |            |       |            |                |           6 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_REFERENCE_OLD_TABLE    |               13 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_REFERENCE_NEW_TABLE    |               14 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_REFERENCE_OLD_ROW      |               15 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | ACTION_REFERENCE_NEW_ROW      |               16 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | CREATED                       |               17 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | SQL_MODE                      |               18 | NULL           | YES         | varchar   |                     8192 |                  24576 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(8192)    |            |       |            |                |        8192 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | DEFINER                       |               19 | NULL           | YES         | varchar   |                       77 |                    231 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(77)      |            |       |            |                |          77 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | CHARACTER_SET_CLIENT          |               20 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | COLLATION_CONNECTION          |               21 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | triggers                | DATABASE_COLLATION            |               22 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_CATALOG                 |                1 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_SCHEMA                  |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_NAME                    |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | DEFINER                       |                4 | NULL           | YES         | varchar   |                       77 |                    231 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(77)      |            |       |            |                |          77 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | TIME_ZONE                     |                5 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_BODY                    |                6 | NULL           | YES         | varchar   |                        8 |                     24 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(8)       |            |       |            |                |           8 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_DEFINITION              |                7 | NULL           | YES         | varchar   |                    65535 |                 196605 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(65535)   |            |       |            |                |       65535 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_TYPE                    |                8 | NULL           | YES         | varchar   |                        9 |                     27 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(9)       |            |       |            |                |           9 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EXECUTE_AT                    |                9 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | INTERVAL_VALUE                |               10 | NULL           | YES         | varchar   |                      256 |                    768 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(256)     |            |       |            |                |         256 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | INTERVAL_FIELD                |               11 | NULL           | YES         | varchar   |                       18 |                     54 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(18)      |            |       |            |                |          18 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | SQL_MODE                      |               12 | NULL           | YES         | varchar   |                     8192 |                  24576 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(8192)    |            |       |            |                |        8192 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | STARTS                        |               13 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | ENDS                          |               14 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | STATUS                        |               15 | NULL           | YES         | varchar   |                       18 |                     54 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(18)      |            |       |            |                |          18 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | ON_COMPLETION                 |               16 | NULL           | YES         | varchar   |                       12 |                     36 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(12)      |            |       |            |                |          12 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | CREATED                       |               17 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | LAST_ALTERED                  |               18 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | LAST_EXECUTED                 |               19 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | EVENT_COMMENT                 |               20 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | ORIGINATOR                    |               21 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | events                  | CHARACTER_SET_CLIENT          |               22 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | COLLATION_CONNECTION          |               23 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | events                  | DATABASE_COLLATION            |               24 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | TABLE_CATALOG                 |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | TABLE_SCHEMA                  |                2 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | TABLE_NAME                    |                3 | NULL           | YES         | varchar   |                       64 |                    192 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(64)      |            |       |            |                |          64 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | VIEW_DEFINITION               |                4 | NULL           | YES         | varchar   |                    65535 |                 196605 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(65535)   |            |       |            |                |       65535 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | CHECK_OPTION                  |                5 | NULL           | YES         | varchar   |                        8 |                     24 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(8)       |            |       |            |                |           8 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | IS_UPDATABLE                  |                6 | NULL           | YES         | varchar   |                        3 |                      9 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(3)       |            |       |            |                |           3 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | DEFINER                       |                7 | NULL           | YES         | varchar   |                       77 |                    231 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(77)      |            |       |            |                |          77 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | SECURITY_TYPE                 |                8 | NULL           | YES         | varchar   |                        7 |                     21 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(7)       |            |       |            |                |           7 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | CHARACTER_SET_CLIENT          |                9 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | views                   | COLLATION_CONNECTION          |               10 | NULL           | YES         | varchar   |                       32 |                     96 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(32)      |            |       |            |                |          32 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | TABLE_CATALOG                 |                1 | NULL           | YES         | varchar   |                      512 |                   1536 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(512)     |            |       |            |                |         512 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | TABLE_SCHEMA                  |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | TABLE_NAME                    |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_NAME                |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | SUBPARTITION_NAME             |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_ORDINAL_POSITION    |                6 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_METHOD              |                7 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | SUBPARTITION_METHOD           |                8 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_EXPRESSION          |                9 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | SUBPARTITION_EXPRESSION       |               10 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_DESCRIPTION         |               11 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | TABLE_ROWS                    |               12 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | AVG_ROW_LENGTH                |               13 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | DATA_LENGTH                   |               14 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | MAX_DATA_LENGTH               |               15 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | INDEX_LENGTH                  |               16 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | DATA_FREE                     |               17 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | CREATE_TIME                   |               18 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | UPDATE_TIME                   |               19 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | CHECK_TIME                    |               20 | NULL           | YES         | datetime  |                     NULL |                   NULL |              NULL |          NULL |               NULL | NULL               | NULL           | datetime         |            |       |            |                |        NULL |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | CHECKSUM                      |               21 | NULL           | YES         | bigint    |                     NULL |                   NULL |                19 |             0 |               NULL | NULL               | NULL           | bigint(20)       |            |       |            |                |          19 |              0 | NULL                  |   NULL |
| NULL          | information_schema | partitions              | PARTITION_COMMENT             |               22 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | NODEGROUP                     |               23 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | partitions              | TABLESPACE_NAME               |               24 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | GRANTEE                       |                1 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | TABLE_CATALOG                 |                2 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | TABLE_SCHEMA                  |                3 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | TABLE_NAME                    |                4 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | COLUMN_NAME                   |                5 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | PRIVILEGE_TYPE                |                6 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
| NULL          | information_schema | column_privileges       | IS_GRANTABLE                  |                7 | NULL           | YES         | varchar   |                     2048 |                   6144 |              NULL |          NULL |               NULL | NULL               | NULL           | varchar(2048)    |            |       |            |                |        2048 |           NULL | NULL                  |   NULL |
+---------------+--------------------+-------------------------+-------------------------------+------------------+----------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+------------------+------------+-------+------------+----------------+-------------+----------------+-----------------------+--------+
251 rows in set (0.10 sec)

@alberttwong alberttwong mentioned this issue Feb 3, 2024
Open
@alberttwong
Copy link
Contributor Author

does not have problems with iceberg.

StarRocks > drop catalog iceberg;
Query OK, 0 rows affected (0.02 sec)

StarRocks > CREATE EXTERNAL CATALOG iceberg
    -> PROPERTIES
    -> (
    ->     "type" = "iceberg",
    ->     "iceberg.catalog.type" = "hive",
    ->     "hive.metastore.uris" = "thrift://hive-metastore:9083",
    ->     "aws.s3.use_instance_profile" = "false",
    ->     "aws.s3.access_key" = "admin",
    ->     "aws.s3.secret_key" = "password",
    ->     "aws.s3.region" = "us-east-1",
    ->     "aws.s3.enable_ssl" = "false",
    ->     "aws.s3.enable_path_style_access" = "true",
    ->     "aws.s3.endpoint" = "http://minio:9000"
    -> );
Query OK, 0 rows affected (0.02 sec)

StarRocks > set catalog iceberg;
Query OK, 0 rows affected (0.00 sec)

StarRocks > show databases;
+--------------------+
| Database           |
+--------------------+
| default            |
| demo               |
| information_schema |
+--------------------+
3 rows in set (0.17 sec)

StarRocks > use demo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
StarRocks > show tables;
+------------------+
| Tables_in_demo   |
+------------------+
| hudi_dimcustomer |
+------------------+
1 row in set (0.05 sec)

StarRocks > select * from hudi_dimcustomer;
+------+-------------+--------------+-------------+---------------+------------+---------------+--------+--------------+---------------+----------------------+---------------------+----------------+----------------+-----------------+
| _c0  | CustomerKey | GeographyKey | FirstName   | LastName      | BirthDate  | MaritalStatus | Gender | YearlyIncome | TotalChildren | NumberChildrenAtHome | Education           | Occupation     | HouseOwnerFlag | NumberCarsOwned |
+------+-------------+--------------+-------------+---------------+------------+---------------+--------+--------------+---------------+----------------------+---------------------+----------------+----------------+-----------------+
| 4096 | 12965       | 543          | Arturo      | Nara          | 1934-09-22 | S             | M      | 10000.0      | 1.0           | 0.0                  | Graduate Degree     | Manual         | 1.0            | 0.0             |
| 4097 | 12966       | 483          | Dustin      | Shan          | 1962-07-26 | S             | M      | 10000.0      | 1.0           | 0.0                  | Graduate Degree     | Manual         | 0.0            | 0.0             |
| 4098 | 12967       | 498          | Grant       | Sharma        | 1962-03-03 | M             | M      | 20000.0      | 1.0           | 0.0                  | Graduate Degree     | Manual         | 0.0            | 0.0             |

@alberttwong alberttwong mentioned this issue Feb 3, 2024
Open
@the-other-tim-brown
Copy link
Contributor

@alberttwong I don't think col stats was enabled when writing out the hudi table so you'll likely need to work with starrocks to figure out how to handle that case.

@alberttwong
Copy link
Contributor Author

Yes. I have this issue cross posted into our github for visibility.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@alberttwong @the-other-tim-brown