sassai commented on issue #1962: URL: https://github.com/apache/hudi/issues/1962#issuecomment-674071601
I'm running Hive within Cloudera Data Platform Public Cloud. I connected to Hive using HUE and Hive CLI. Beeline Connection: ```console [root@engineeringhub-master3 ~]# beeline --hiveconf hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat --hiveconf hive.stats.autogather=false SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.2.0-1.cdh7.2.0.p0.3758356/jars/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.2.0-1.cdh7.2.0.p0.3758356/jars/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'log4j2.debug' to show Log4j2 internal initialization logging. WARNING: Use "yarn jar" to launch YARN applications. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.2.0-1.cdh7.2.0.p0.3758356/jars/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.2.0-1.cdh7.2.0.p0.3758356/jars/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to jdbc:hive2://engineeringhub-master3.mtag-fas.ft71-kqhq.cloudera.site:2181/default;httpPath=cliservice;principal=hive/[email protected];serviceDiscoveryMode=zooKeeper;ssl=true;transportMode=http;zooKeeperNamespace=hiveserver2 20/08/14 13:14:12 [main]: INFO jdbc.HiveConnection: Connected to engineeringhub-master3.mtag-fas.ft71-kqhq.cloudera.site:10001 20/08/14 13:14:12 [main]: WARN jdbc.HiveConnection: Failed to connect to engineeringhub-master3.mtag-fas.ft71-kqhq.cloudera.site:10001 20/08/14 13:14:12 [main]: ERROR jdbc.Utils: Unable to read HiveServer2 configs from ZooKeeper Error: Could not open client transport for any of the Server URI's in ZooKeeper: Failed to open new session: java.lang.IllegalArgumentException: Cannot modify hive.input.format at runtime. It is not in list of params that are allowed to be modified at runtime (state=08S01,code=0) Beeline version 3.1.3000.7.2.0.0-237 by Apache Hive beeline> ``` Later on we would like to use JDBC-Connections from external tools like PowerBI or Dbeaver. I can query and filter all columns excluding the partiton columns: year, month, day, hour, minute. If I apply aggregations on the partition columns I can filter them. This is very odd. ```sql SELECT DISTINCT(minute), count(minute) FROM greentech.iot_device_ro GROUP BY minute ; ``` but ```sql SELECT * FROM greentech.iot_device_ro WHERE minute=50 ; ``` returns an emtpy result list. Thank you for the quick response. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
