2022-05-20 17:07:08,853 INFO [main] jdbc.Utils (Utils.java:parseURL(304)) - Supplied authorities: 10.50.254.45:10000 2022-05-20 17:07:08,859 INFO [main] jdbc.Utils (Utils.java:parseURL(391)) - Resolved authority: 10.50.254.45:10000 +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | _hive.hdfs.session.path=hdfs://nameservice1/inceptor1/tmp/hive/anonymous/437 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | _hive.local.session.path=/tmp/hive/4372b424-0ae0-4ad6-ba7b-bdbe19ac865f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | _hive.tmp_table_space=hdfs://nameservice1/inceptor1/tmp/hive/anonymous/4372b | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | antlr.rich.errorinfo=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | application.enable.wal=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | character.literal.as.string=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | character.type.length.zero.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | client.dialect=oracle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | client.transport.sniff=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | cluster.name=cluster | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.aggressive=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.duplicateedge=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.dynamic.type.throws.exception=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.fast.count.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.lang=cypher_transwarp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.limit.statement.opt=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.local.fast.simple.map=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.local.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.query.engine.optimizer.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.query.lookup.force=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.remote.read.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.result.file.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.serde.type=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.split.phase.limit.opt=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.split.phase.limit.sample.one=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.split.phase.limit.scale.factor=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | crux.struct.id.equal=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | data.dictionary.install=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.autoCreateSchema=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.autoStartMechanism=SchemaTable | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.autoStartMechanismMode=checked | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.cache.level2=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.cache.level2.type=none | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.connection.acquire.increment=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.connection.max=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.connection.min=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.connectionPool.maxPoolSize=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.connectionPoolingType=HikariCP | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.fixedDatastore=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.identifierFactory=datanucleus1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.plugin.pluginRegistryBundleCheck=LOG | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.rdbms.useLegacyNativeValueStrategy=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.schema.autoCreateAll=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.schema.validateColumns=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.schema.validateConstraints=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.schema.validateTables=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.storeManagerType=rdbms | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.transactionIsolation=read-committed | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.validateColumns=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.validateConstraints=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | datanucleus.validateTables=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.balancer.address=0.0.0.0:0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.balancer.block-move.timeout=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.balancer.keytab.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.balancer.max-no-move-interval=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.block.access.key.update.interval=600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.block.access.token.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.block.access.token.lifetime=600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.block.scanner.volume.bytes.per.second=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.blockreport.initialDelay=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.blockreport.intervalMsec=21600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.blockreport.split.threshold=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.blocksize=134217728 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.bytes-per-checksum=512 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.cachereport.intervalMsec=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client-write-packet-size=65536 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.block.write.replace-datanode-on-failure.best-effort=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.block.write.replace-datanode-on-failure.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.block.write.replace-datanode-on-failure.policy=DEFAULT | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.block.write.retries=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.cached.conn.retry=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.context=default | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.datanode-restart.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.domain.socket.data.traffic=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.connection.retries=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.connection.retries.on.timeouts=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.max.attempts=15 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.proxy.provider.nameservice1=org.apache.hadoop.hdfs.serve | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.sleep.base.millis=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.failover.sleep.max.millis=15000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.file-block-storage-locations.num-threads=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.file-block-storage-locations.timeout.millis=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.https.keystore.resource=ssl-client.xml | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.https.need-auth=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.mmap.cache.size=256 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.mmap.cache.timeout.ms=3600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.mmap.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.mmap.retry.timeout.ms=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.read.shortcircuit=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.read.shortcircuit.skip.checksum=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.read.shortcircuit.streams.cache.expiry.ms=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.read.shortcircuit.streams.cache.size=256 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.short.circuit.replica.stale.threshold.ms=1800000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.slow.io.warning.threshold.ms=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.socket-timeout=120000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.socket.send.buffer.size=131072 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.use.datanode.hostname=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.use.legacy.blockreader.local=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.client.write.exclude.nodes.cache.expiry.interval.millis=600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.data.transfer.protection=authentication | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.address=0.0.0.0:50010 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.available-space-volume-choosing-policy.balanced-space-preferenc | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.available-space-volume-choosing-policy.balanced-space-threshold | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.balance.bandwidthPerSec=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.block-pinning.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.block.id.layout.upgrade.threads=12 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.bp-ready.timeout=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.cache.revocation.polling.ms=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.cache.revocation.timeout.ms=900000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.data.dir=/vdir/BIreport/hadoop/data | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.data.dir.perm=755 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.directoryscan.interval=21600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.directoryscan.threads=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.directoryscan.throttle.limit.ms.per.sec=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.dns.interface=default | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.dns.nameserver=default | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.drop.cache.behind.reads=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.drop.cache.behind.writes=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.du.reserved=41191900774 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.failed.volumes.tolerated=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.fsdatasetcache.max.threads.per.volume=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.handler.count=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.hdfs-blocks-metadata.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.http.address=0.0.0.0:50075 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.https.address=0.0.0.0:50475 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.ipc.address=0.0.0.0:50020 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.max.locked.memory=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.max.transfer.threads=4096 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.readahead.bytes=4194304 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.scan.period.hours=504 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.shared.file.descriptor.paths=/dev/shm,/tmp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.slow.io.warning.threshold.ms=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.sync.behind.writes=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.transfer.socket.recv.buffer.size=131072 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.transfer.socket.send.buffer.size=131072 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.datanode.use.datanode.hostname=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.default.chunk.view.size=32768 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.domain.socket.path=/var/run/hdfs1/dn_socket | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.encrypt.data.transfer=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.encrypt.data.transfer.cipher.key.bitlength=128 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.ha.automatic-failover.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.ha.automatic-failover.enabled.nameservice1=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.ha.log-roll.period=120 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.ha.namenodes.nameservice1=nn1,nn2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.ha.tail-edits.period=60 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.heartbeat.interval=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.hosts.exclude=/etc/hdfs1/conf/exclude-list.txt | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.http.policy=HTTP_ONLY | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.https.server.keystore.resource=ssl-server.xml | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.image.compress=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.image.compression.codec=org.apache.hadoop.io.compress.DefaultCodec | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.image.transfer.bandwidthPerSec=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.image.transfer.chunksize=65536 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.image.transfer.timeout=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.journalnode.edits.dir=/hadoop/journal | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.journalnode.http-address=0.0.0.0:8480 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.journalnode.https-address=0.0.0.0:8481 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.journalnode.rpc-address=0.0.0.0:8485 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.lock.suppress.warning.interval=10s | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.mover.max-no-move-interval=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.accesstime.precision=3600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.acls.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.audit.loggers=default | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.avoid.read.stale.datanode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.avoid.write.stale.datanode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.backup.address=0.0.0.0:50100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.backup.http-address=0.0.0.0:50105 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.block-placement-policy.default.prefer-local-node=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.blocks.per.postponedblocks.rescan=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.check.period=60 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.dir=file://${hadoop.tmp.dir}/dfs/namesecondary | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.edits.dir=${dfs.namenode.checkpoint.dir} | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.max-retries=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.period=3600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.checkpoint.txns=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.datanode.registration.ip-hostname-check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.decommission.blocks.per.interval=500000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.decommission.interval=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.decommission.max.concurrent.tracked.nodes=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.delegation.key.update-interval=86400000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.delegation.token.max-lifetime=604800000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.delegation.token.renew-interval=86400000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.edit.log.autoroll.check.interval.ms=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.edit.log.autoroll.multiplier.threshold=2.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.edits.dir=${dfs.namenode.name.dir} | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.edits.journal-plugin.qjournal=org.apache.hadoop.hdfs.qjournal.c | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.edits.noeditlogchannelflush=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.enable.retrycache=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.max-blocks-per-file=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.max-component-length=255 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.max-directory-items=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.max-xattr-size=16384 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.max-xattrs-per-inode=32 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fs-limits.min-block-size=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.fslock.fair=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.handler.count=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.heartbeat.recheck-interval=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.http-address=0.0.0.0:50070 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.http-address.nameservice1.nn1=bireport2:50070 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.http-address.nameservice1.nn2=bireport3:50070 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.https-address=0.0.0.0:50470 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.inotify.max.events.per.rpc=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.invalidate.work.pct.per.iteration=0.32f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.kerberos.internal.spnego.principal=${dfs.web.authentication.ker | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.kerberos.principal.pattern=* | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.lazypersist.file.scrub.interval.sec=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.list.cache.directives.num.responses=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.list.cache.pools.num.responses=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.list.encryption.zones.num.responses=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.lock.detailed-metrics.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.max.extra.edits.segments.retained=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.max.objects=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.name.dir=/vdir/BIreport/hadoop/namenode_dir | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.name.dir.restore=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.num.checkpoints.retained=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.num.extra.edits.retained=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.path.based.cache.block.map.allocation.percent=0.25 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.path.based.cache.refresh.interval.ms=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.path.based.cache.retry.interval.ms=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.quota.init-threads=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.read-lock-reporting-threshold-ms=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.reject-unresolved-dn-topology-mapping=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.replication.considerLoad=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.replication.interval=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.replication.min=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.replication.work.multiplier.per.iteration=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.resource.check.interval=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.resource.checked.volumes.minimum=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.resource.du.reserved=104857600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.retrycache.expirytime.millis=600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.retrycache.heap.percent=0.03f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.rpc-address.nameservice1.nn1=bireport2:8020 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.rpc-address.nameservice1.nn2=bireport3:8020 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.safemode.extension=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.safemode.min.datanodes=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.safemode.threshold-pct=0.999f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.secondary.http-address=0.0.0.0:50090 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.secondary.https-address=0.0.0.0:50091 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.shared.edits.dir.nameservice1=qjournal://bireport1:8485;birepor | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.stale.datanode.interval=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.startup.delay.block.deletion.sec=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.support.allow.format=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.top.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.top.num.users=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.top.window.num.buckets=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.top.windows.minutes=1,5,25 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.write-lock-reporting-threshold-ms=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.write.stale.datanode.ratio=0.5f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.namenode.xattrs.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.nameservices=nameservice1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.permissions.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.permissions.superusergroup=hbase | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.reformat.disabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.replication=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.replication.max=512 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.secondary.namenode.kerberos.internal.spnego.principal=${dfs.web.authenti | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.short.circuit.shared.memory.watcher.interrupt.check.ms=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.storage.policy.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.stream-buffer-size=4096 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.support.append=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.user.home.dir.prefix=/user | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.webhdfs.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | dfs.webhdfs.user.provider.user.pattern=^[A-Za-z_][A-Za-z0-9._-]*[$]?$ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | discovery.zen.minimum_master_nodes=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | discovery.zen.ping.unicast.hosts=bireport1:9300,bireport2:9300,bireport3:930 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.add.props.ack.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.add.props.master.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.agg.columns=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.aggregation.buckets.threshold=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.clientscan=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.create.table.ack.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.create.table.master.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.data.corrupt.ignored=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.filter.in.to.union=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.filter.in.to.union.maxnum.threshold=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.filter.in.to.union.num.threshold=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.flush.with.refresh=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.insert.batch.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.insert.optype=upsert | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.insert.without.rowkey=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.intelligent.scroll.iterator=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.large.result.set.optimization=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.map.tasks=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.matches.slop.size=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.metacache.concurrency.level=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.metacache.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.metacache.expire.time=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.metacache.maxsize=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.orderby.batch.size.limit=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.restclient.count=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.return.limit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.select.batch.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.stricted.analyzer=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.wait.cluster.health.timeout=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.write.external.table.default.type=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | esdrive.xcontent.type=JSON | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | fs.har.impl=org.apache.hadoop.hive.shims.HiveHarFileSystem | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | fs.scheme.class=dfs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | graph.checkpoint.frequency=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | graph.checkpoint.local=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | graph.unbiased.threshold=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | graph.zk.base_path=/graph | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | graph.zk.quorum=bireport1:2181,bireport2:2181,bireport3:2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hadoop.bin.path=/usr/lib/hadoop/bin/hadoop | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hadoop.fuse.connection.timeout=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hadoop.fuse.timer.period=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hadoop.hdfs.configuration.version=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.client.delete.write.size=1024 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.client.retries.number=14 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.client.scanner.caching=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.fusionrow.filter=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.master.port=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.regions.slop=/hbase1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.regionserver.port=60020 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.table.default.storage.type=string | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.zookeeper.leaderport=3888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.zookeeper.peerport=180000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.zookeeper.property.clientPort=2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hbase.zookeeper.quorum=bireport1:2181,bireport2:2181,bireport3:2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.analyze.stmt.collect.partlevel.stats=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.archive.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.join.noconditionaltask=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.join.noconditionaltask.size=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.sortmerge.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.sortmerge.join.bigtable.selection.policy=org.apache.hadoop | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.convert.sortmerge.join.to.mapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.auto.progress.timeout=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.autogen.columnalias.prefix.includefuncname=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.autogen.columnalias.prefix.label=_c | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.batch.heartbeat.size=200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.binary.record.max.length=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cache.expr.evaluation=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cache.io.format.max.entries=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cache.properties.max.entries=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cache.table.desc.max.entries=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cbo.cnf.maxnodes=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cli.errors.ignore=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cli.pretty.output.num.cols=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cli.print.current.db=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cli.print.header=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cli.prompt=transwarp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cluster.delegation.token.store.class=org.apache.hadoop.hive.thrift.Memo | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.cluster.delegation.token.store.zookeeper.znode=/hive/cluster/delegation | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compact.allow.task.retry=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compact.block.interval=180 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.abortedtxn.threshold=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.check.interval=90 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.clean.ctc=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.clean.ctc.interval=1200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.cleaner.run.interval=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.ctc.threshold=200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.delta.num.threshold=50 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.delta.num.threshold.without.base=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.delta.pct.threshold=0.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.initiator.on=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.max.num.delta=50000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.sleep.time.for.read.only.metastore=1800 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.split.mode=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.table.open.txnid=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.worker.max.st.times=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.worker.run.interval=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.worker.threads=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compactor.worker.timeout=86400 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compat=0.12 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compile.lock=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.compute.splits.in.am=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.conf.optimization.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.conf.restricted.list=hive.security.authenticator.manager,hive.security. | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.conf.validation=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.correlated.subquery.ast.transform=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.correlated.subquery.ast.transform.scalar.check=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.correlated.subquery.conversion.join.type=innerjoin | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.counters.group.name=HIVE | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.crud.dynamic.partition=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ddl.createtablelike.properties.whitelist=transactional,storage_handler, | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.debug.localtask=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.decimal.wrdecimal.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.decode.partition.name=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.default.fileformat=TextFile | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.default.rcfile.serde=org.apache.hadoop.hive.serde2.columnar.LazyBinaryC | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.display.partition.cols.separately=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.downloaded.resources.dir=/tmp/4372b424-0ae0-4ad6-ba7b-bdbe19ac865f_reso | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.enforce.bucketing=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.enforce.bucketmapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.enforce.sorting=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.enforce.sortmergebucketmapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.entity.separator=@ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.error.on.empty.partition=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.except.aggregateratio=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exception.debug=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exclusive.lock.max.waiting.time=120 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.check.crossproducts=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.compress.intermediate=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.compress.output=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.concatenate.check.index=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.copyfile.maxsize=33554432 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.counters.pull.interval=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.default.partition.name=__HIVE_DEFAULT_PARTITION__ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.drop.ignorenonexistent=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.dynamic.partition=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.dynamic.partition.mode=nonstrict | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.infer.bucket.sort=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.infer.bucket.sort.num.buckets.power.two=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.job.debug.capture.stacktraces=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.job.debug.timeout=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.ladderscratchdir=hdfs://nameservice1/inceptor1/tmp/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.local.scratchdir=/tmp/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.max.created.files=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.max.dynamic.partitions=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.max.dynamic.partitions.pernode=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.mode.local.auto=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.mode.local.auto.input.files.max=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.mode.local.auto.inputbytes.max=134217728 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.block.padding.tolerance=0.05 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.compression.strategy=SPEED | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.block.padding=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.block.size=268435456 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.buffer.size=262144 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.compress=ZLIB | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.row.index.stride=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.default.stripe.size=268435456 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.dictionary.key.size.threshold=0.8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.encoding.strategy=SPEED | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.memcheck.size=4096 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.memory.pool=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.skip.corrupt.data=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.use.wide.buffersize=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.orc.zerocopy=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.parallel=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.parallel.thread.number=8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.perf.logger=org.apache.hadoop.hive.ql.log.PerfLogger | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.rcfile.use.explicit.header=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.rcfile.use.sync.cache=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.reducers.bytes.per.reducer=1000000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.reducers.max=999999 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.rowoffset=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.schema.evolution=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.scratchdir=hdfs://nameservice1/inceptor1/tmp/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.scratchdir.local=file:///dev/shm | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.script.allow.partial.consumption=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.script.maxerrsize=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.script.trust=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.show.job.failure.debug.info=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.stagingdir=.hive-staging | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.submit.local.task.via.child=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.submitviachild=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exec.tasklog.debug.timeout=20000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.execution.engine=mr | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.exim.uri.scheme.whitelist=hdfs,pfile | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.explain.dependency.append.tasktype=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.expr.cse=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.expr.cse.nested.filter.exploring=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.extract.aggregateratio=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.fetch.output.serde=org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.fetch.task.aggr=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.fetch.task.conversion=minimal | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.file.max.footer=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.fileformat.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.filesink.skip.empty.file=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.aggregateratio=0.6 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.iter.single.rollup=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.mapaggr.checkinterval=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.orderby.position.alias=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.position.alias=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.groupby.skewindata=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hadoop.supports.splittable.combineinputformat=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hashtable.initialCapacity=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hashtable.key.count.adjustment=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hashtable.loadfactor=0.75 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hbase.wal.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.heartbeat.interval=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hmshandler.force.reload.conf=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hmshandler.retry.attempts=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hmshandler.retry.interval=2000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hwi.listen.host=0.0.0.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hwi.listen.port=9999 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.hwi.war.file=lib/hive-hwi-0.8.1.war | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ignore.mapjoin.hint=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.in.test=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.index.compact.binary.search=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.index.compact.file.ignore.hdfs=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.index.compact.query.max.entries=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.index.compact.query.max.size=10737418240 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.insert.into.external.tables=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.insert.into.multilevel.dirs=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.insert.values.local=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.intersect.aggregateratio=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.jobname.length=50 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.join.aggregateratio=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.join.cache.size=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.join.emit.interval=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.keywords.ignore.case.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.optimize.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.optimize.fetch.max=50000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.optimize.limit.file=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.pushdown.memory.usage=-1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.query.max.table.partition=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.limit.row.max.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.localize.resource.num.wait.attempts=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.lock.manager=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveL | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.lock.mapred.only.operation=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.lock.numretries=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.lock.sleep.between.retries=15 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.lockmgr.zookeeper.default.partition.name=__HIVE_DEFAULT_ZOOKEEPER_PARTI | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.log.explain.output=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.log.sql.truncate=8388608 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.aggr=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.aggr.hash.force.flush.memory.threshold=0.9 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.aggr.hash.min.reduction=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.aggr.hash.percentmemory=0.4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.groupby.sorted=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.map.groupby.sorted.testmode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.bucket.cache.size=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.check.memory.rows=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.followby.gby.localtask.max.memory.usage=0.55 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.followby.map.aggr.hash.percentmemory=0.3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.lazy.hashtable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.localtask.max.memory.usage=0.9 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.optimized.hashtable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.optimized.hashtable.wbsize=10485760 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.optimized.keys=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapjoin.smalltable.filesize=25000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapper.cannot.span.multiple.partitions=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapred.local.mem=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapred.mode=nonstrict | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapred.partitioner=org.apache.hadoop.hive.ql.io.DefaultHivePartitioner | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapred.reduce.tasks.speculative.execution=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.mapred.supports.subdirectories=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.materializedview.fileformat=ORC | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.materializedview.serde=org.apache.hadoop.hive.ql.io.orc.OrcSerde | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.max.allowed.repeated.deadlocks=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.max.partition.locks.per.table=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.max.show.compactions=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.current.job.concatenate.list.bucketing=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.current.job.concatenate.list.bucketing.depth=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.current.job.has.dynamic.partitions=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.input.format.block.level=org.apache.hadoop.hive.ql.io.rcfile.merg | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.mapfiles=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.mapredfiles=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.nway.joins=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.orcfile.stripe.level=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.rcfile.block.level=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.size.per.task=256000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.merge.smallfiles.avgsize=16000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metadata.move.exported.metadata.to.trash=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.archive.intermediate.archived=_INTERMEDIATE_ARCHIVED | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.archive.intermediate.extracted=_INTERMEDIATE_EXTRACTED | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.archive.intermediate.original=_INTERMEDIATE_ORIGINAL | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.authorization.storage.checks=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.batch.retrieve.max=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.batch.retrieve.table.partition.max=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.cache.pinobjtypes=Table,StorageDescriptor,SerDeInfo,Partition | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.client.connect.retry.delay=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.client.socket.timeout=86400000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.connect.retries=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.direct.sql.batch.size=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.disallow.incompatible.col.type.changes=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.ds.retry.attempts=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.event.clean.freq=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.event.db.listener.timetolive=86400 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.event.expiry.duration=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.execute.setugi=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.expression.proxy=org.apache.hadoop.hive.ql.optimizer.ppr.Part | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.failure.retries=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.filter.hook=org.apache.hadoop.hive.metastore.DefaultMetaStore | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.force.reload.conf=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.fs.handler.class=org.apache.hadoop.hive.metastore.HiveMetaSto | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.integral.jdo.pushdown=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.kerberos.principal=hive-metastore/_HOST@EXAMPLE.COM | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.orm.retrieveMapNullsAsEmptyStrings=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.rawstore.impl=org.apache.hadoop.hive.metastore.ObjectStore | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.sasl.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.schema.verification=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.server.max.message.size=104857600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.server.max.threads=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.server.min.threads=200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.server.tcp.keepalive=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.thrift.compact.protocol.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.thrift.framed.transport.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.try.direct.sql=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.try.direct.sql.ddl=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.uris=thrift://bireport2:9083,thrift://bireport3:9083 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.metastore.warehouse.dir=hdfs://nameservice1/inceptor1/user/hive/warehou | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.multi.insert.move.tasks.share.dependencies=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.multigroupby.singlereducer=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.new.job.grouping.set.cardinality=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.bucketingsorting=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.bucketmapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.bucketmapjoin.sortedmerge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.constant.folding.join=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.constant.propagation=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.constant.propagation.join=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.correlation=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.cp=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.distinct.rewrite=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert.cluster.by.random=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert.column.check=nonstrict | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert.order.override=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert.partition.override=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.dynamic.partition.insert.supported.table.only=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.fast.lineage=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.filter.stats.reduction=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.groupby=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.index.autoupdate=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.index.filter=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.index.filter.compact.maxsize=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.index.filter.compact.minsize=5368709120 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.index.groupby=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.limittranspose=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.limittranspose.reductionpercentage=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.limittranspose.reductiontuples=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.listbucketing=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.local.orderby.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.metadataonly=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.multigroupby.common.distincts=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.partial.ppd=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.point.lookup=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.point.lookup.min=31 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.ppd=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.ppd.storage=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.ppd.windowing=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.readcolumn=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.reducededuplication=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.reducededuplication.min.reducer=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.sampling.orderby=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.sampling.orderby.number=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.sampling.orderby.percent=0.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.skewjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.skewjoin.compiletime=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.sort.dynamic.partition=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.optimize.union.remove=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.orc.cache.stripe.details.size=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.orc.compute.splits.num.threads=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.orc.row.index.stride.dictionary.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.orc.splits.include.file.footer=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.orderby.position.alias=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.outerjoin.supports.filters=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.parquet.timestamp.skip.conversion=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.part.as.hyperbase.table=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.plan.serialization.format=kryo | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ppd.recognizetransivity=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ppd.remove.duplicatefilters=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ppd.remove.partialfilters=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ppd.subquery.reducesink=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ppd.subqueryfilter=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.query.result.fileformat=TextFile | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.query.user=anonymous | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.query.user.passthrough=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.querylog.enable.plan.progress=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.querylog.location=/tmp/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.querylog.plan.progress.interval=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.reducer.control.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.reducer.control.min.ratio.common=0.2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.reducer.control.min.ratio.gby=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.reducer.control.partfilter.addedvalue=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.resultset.use.unique.column.names=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.rework.mapredwork=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.rewrite.oscd=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.rpc.query.plan=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.rpp.show.results=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.sample.seednumber=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.scratch.dir.permission=711 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.scratch.dir.root.permission=777 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.auto.progress=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.operator.id.env.var=HIVE_SCRIPT_OPERATOR_ID | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.operator.truncate.env=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.recordreader=org.apache.hadoop.hive.ql.exec.TextRecordReader | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.recordwriter=org.apache.hadoop.hive.ql.exec.TextRecordWriter | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.script.serde=org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.Hadoo | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authorization.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.autho | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authorization.shared=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authorization.sqlstd.confwhitelist=hive\.auto\..*|hive\.cbo\.. | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.authorization.task.factory=org.apache.hadoop.hive.ql.parse.aut | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.command.whitelist=set,reset,dfs,add,deleteres,compile,stop,sta | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.metastore.authenticator.manager=org.apache.hadoop.hive.ql.secu | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.metastore.authorization.auth.reads=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.security.metastore.authorization.manager=org.apache.hadoop.hive.ql.secu | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.select.merge.duplicate.column=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.serdes.using.metastore.for.schema=org.apache.hadoop.hive.ql.io.orc.OrcS | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server.read.socket.timeout=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server.tcp.keepalive=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.allow.user.substitution=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.async.exec.keepalive.time=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.async.exec.shutdown.timeout=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.async.exec.threads=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.async.exec.wait.queue.size=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication=NONE | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.cas.acceptAnyProxy=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.cas.allow.proxy=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.cas.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.guardian.token.api=/api/v1/verifyAccessToken | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.guardian.token.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.authentication.oauth2.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.client.so.timeout=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.enable.doAs=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.idle.operation.timeout=28800000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.idle.plsql.operation.timeout=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.idle.session.timeout=43200000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.logging.operation.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.logging.operation.log.location=/tmp/null/operation_logs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.logging.operation.verbose=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.long.polling.timeout=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.map.fair.scheduler.queue=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.max.start.attempts=30 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.session.abandon.threshold=172800 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.session.check.interval=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.table.type.mapping=CLASSIC | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.exponential.backoff.slot.length=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.max.idle.time=1800 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.max.worker.threads=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.min.worker.threads=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.path=cliservice | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.port=10001 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.http.worker.keepalive.time=60 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.login.timeout=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.max.message.size=104857600 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.max.worker.threads=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.min.worker.threads=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.port=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.sasl.qop=auth | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.thrift.worker.keepalive.time=60 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.cache.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.cache.expire.time=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.cache.max.size=200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.rest.client.connection.timeout=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.rest.client.max.conns.per.route=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.rest.client.max.conns.total=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.token.rest.client.socket.timeout=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.transport.mode=binary | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.use.SSL=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.server2.zookeeper.namespace=hiveserver2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.service.id=inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.service.type=INCEPTOR | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.session.history.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.session.id=4372b424-0ae0-4ad6-ba7b-bdbe19ac865f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.session.silent=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.show.rowcount=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.skewjoin.key=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.skewjoin.mapjoin.map.tasks=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.skewjoin.mapjoin.min.split=33554432 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.smbjoin.cache.rows=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.ssl.protocol.blacklist=SSLv2,SSLv3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stageid.rearrange=none | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.start.cleanup.scratchdir=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.atomic=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.autogather=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.collect.rawdatasize=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.collect.scancols=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.collect.tablekeys=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.dbclass=fs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.deserialization.factor=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.fetch.column.stats=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.fetch.partition.stats=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.join.factor=1.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.key.prefix=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.key.prefix.max.length=150 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.key.prefix.reserve.length=24 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.list.num.entries=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.map.num.entries=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.map.parallelism=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.max.variable.length=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.reliable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.stats.retries.wait=3000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.support.concurrency=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.support.quoted.identifiers=column | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.support.subquery.join.conversion.count=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.task.progress=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.test.authz.sstd.hs2.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.test.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.test.mode.prefix=test_ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.test.mode.samplefreq=32 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.transform.escape.input=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.transpose.aggr.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.txn.max.open.batch=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.txn.timeout=300000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.typecheck.on.insert=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.udf.codegen=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.udf.cse=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.udtf.auto.progress=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.unlock.numretries=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.update.subquery.left.join.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.users.in.admin.role=hive,hue | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.variable.substitute=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.variable.substitute.depth=40 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.vectorized.groupby.checkinterval=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.vectorized.groupby.flush.percent=0.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.vectorized.groupby.maxentries=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.warehouse.subdir.inherit.perms=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.window.iterator.directly=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.window.spill.size=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.clean.extra.nodes=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.client.port=2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.connection.basesleeptime=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.connection.max.retries=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.namespace=hive_zookeeper_namespace | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.quorum=bireport1:2181,bireport2:2181,bireport3:2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.sequence.namespace=/hive/sequence | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hive.zookeeper.session.timeout=1200000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.aggressive.filter=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.automerge.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.automerge.filesize=268435456 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.automerge.mergesize=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.bulk.read.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.checkpoint.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.columnblock.cached=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compaction.async.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compaction.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compute.globalindex.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compute.globalindex.profile=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compute.globalindex.seqread=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.compute.optimization=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fast.read.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fastskip.batchsize=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fastskip.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fastskip.frontend.var=16,128,2000,200,100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fastskip.trace.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.filter.block=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fullcompaction.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fullcompaction.filenum.threshold=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fullcompaction.filesize.threshold=33554432 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.fullcompaction.single.task.filesize.threshold=134217728 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gi.insert.async.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gi.statistics.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.optimize.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.plan.basetable.ratio=52428800 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.plan.mapjoin.limit=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.plan.maxdelta=1000000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.plan.type=shuffle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.shuffle.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.smalltable.exception.size=4294967296 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.gimutate.smalltable.threshold=67108864 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.global.index.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.autoskip.filesize.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.autoskip.filesize.threshold=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.autoskip.selectivity.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.autoskip.selectivity.threshold=1.0E-8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.compactionratio=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.comparable.ratio=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.queryblocks.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.readlimit.count=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.readlimit.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.rebuild.force.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.sort=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.splitsize=5120 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.globalindex.tmp.readlimit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.hold.wlock=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.index.allcolumns=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.insert.nullvalue.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.join.threshold=10485760 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.local.batch.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.majorcompaction.delta.filesize.ratio=0.2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.majorcompaction.enforced=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.mapjoin.infilter.pushdown.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.mapjoin.opts=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.merge.file.read.size=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.meta.cache=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.meta.reused=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.metrics=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.minorcompaction.delta.filenum.threshold=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.minorcompaction.enforced=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.molten.concurrency=64 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.molten.resultsize=16 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.orderby.limit.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.orderby.limit.num=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.piece.num.limit=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.predicate.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.query.blocks.num.limit=50 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.recovery.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.remote.forceopen=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.replicate.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.replicate.num=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.segment.compression.codec=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.seqread.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.shiva.capacity.store.ratio=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.shiva.capacity.unit=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.shiva.meta=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.shiva.replicate.num=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.shiva.tablet.num=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.single.replica.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.ssd.opt=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.statistics.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.tablescan.ratio=-1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.transaction.timeout=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.treat.singlecube.error=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.validproperty=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.wait.for.commit.finish=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.waitlock.timeout=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.webui.maxblock=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.wrdecimal.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | holodesk.zookeeper.quorum=bireport1:2181,bireport2:2181,bireport3:2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.auto.flush=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.bigint.transform=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.bulkload.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.bulkload.hyperbase.table=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.cacheblocks=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.esasstorage=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.fill.null.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.global.lookup.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.htrace.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.integer.transform=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.keepnullcolumn=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.local.run.scan=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.lookahead=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.map.tasks=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.needtotalhints=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.parallelscan=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.predicate.cbo=io.transwarp.hyperbase.predicate.cbo.PredicateCBOImp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.predicate.cbo.alg=championship | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.predicate.cbo.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.predicate.rbo=io.transwarp.hyperbase.rbo.PredicateRBOImpl | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.predicate.rbo.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.pretreatment.conf.keys=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.reader=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.reader.autoflush=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.reader.split.size=134217728 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.rowkey.delim=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.rowkey.delim.index=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.scan.index.test=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.searchsize=50 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.smart.split=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.split=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.split.size=1073741824 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.subsplit.size=134217728 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.transaction.sessionid=4372b424-0ae0-4ad6-ba7b-bdbe19ac865f | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.transactionmanager=org.apache.hadoop.hive.hbase.transaction.Transa | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.use.meta.cache=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperbase.usescroll=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperdrive.data.corrupt.ignored=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperdrive.decimal.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperdrive.double.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperdrive.float.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | hyperdrive.index.autoselect=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.accept.system.task=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.acid.reader.mode=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.audit.user.white.list=admin | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.automerge.maptask=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cache.flag.checkTableName=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.calcite.insert.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.calcite.optimizer.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.calcite.subquery.non.correlated=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.calcite.subquery.withas=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.combine.hint.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.bigtable.rowcount.threshold=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.bucketjoin.costfactor=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.commonjoin.costfactor=8.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.cpu=0.000001 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.fakedata=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.labelndv=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.node.pkndv=100000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.node.props.hs=50000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.node.props.ls=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.node.rownum=100000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.node.ukindex=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.fkndv=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.pkndv=1000000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.props.hs=100000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.props.ls=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.rownum=1000000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.crux.stats.rel.ukindex=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.extended=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.forcemj.costfactor=0.8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.glkjoin.dt.costfactor=10.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.glkjoin.mt.costfactor=100.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.hdfs.read=1.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.hdfs.write=10.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.local.fs.read=4.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.local.fs.write=4.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.mapjoin.costfactor=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.maxndv=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.network=150.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.partmj.costfactor=0.6 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.costmodel.smalltable.rowcount.threshold=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.columnprune.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.constantfolding.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.crosspath.multijoin.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.filtermerge.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.filtermerge.postjr.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.joinreorder.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.joinreorder.heuristic.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.joinreorder.sample.startfactor=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.postcpppd.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.ppd.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.ppd.postjr.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.projectmerge.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.opt.projectmerge.postjr.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.crux.stats.cache.level=stmt | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.cypher.ignore.exception=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.cypher.support.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.joincount.min=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.mdprovider.extended=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.outer.inner.reorder=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.outerjoin.conversion=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.part.join.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.pre.agg.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.pre.agg.join.min.ratio=100.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.returnpath.hiveop=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.rowbased.dim.mapjoin=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.rowbased.mapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.rowbased.mapjoin.reduce.factor=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.rowbased.subq.mapjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.selectop.remove=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.sqlblocker.rowcount.threshold=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.static.mdprovider=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.stats.integrity=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cbo.withas.reorder=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.column.compress=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.column.partitionSize.mb=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.conf.validation=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.convert.subq.to.mapjoin=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.correlated.subquery.qb.transform=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cross.join.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.crud.strict.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cube.ndv.relativesd=0.05 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.cube.segment.pruner=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.data.audit=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.data.audit.pre.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.data.audit.statement=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.data.type.conversion.check=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.date.show.time=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decflt.rounding=round_half_up | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decimal.default.precision=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decimal.default.scale=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decimal.display.padding.zero=dialect | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decimal.null.check=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.decimal.textfile.padding.zero=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.delete=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.deploy.zookeeper.quorum=localhost:2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.emptyrdd.shortcut=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.enable.temptable.crud=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.error.table.bucketing=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.error.table.bucketsize=29 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.evaluate.datetime.runtime=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.explain.mode=inceptor | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.infilter.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.max.num.infilter=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.max.num.infilter.nostats=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.max.per.selectivity=0.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.max.total.selectivity=0.01 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.min.density=0.9 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.filterjoin.pushdown.filter.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.floating.scale.decimal=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.fwc.ignore.invalid.char=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.in.conversion.threadhold=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.infilter.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.insert.data.format.check=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.insert.type.conversion=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.iso.column.pruner=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.iso.column.pruner.collect.ref=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.iso.dead.temptable.remove=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.iso.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.iso.temptable.inline=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.join.discardnull=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.managed.table.drop.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.managed.table.location.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.array=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.arraysize=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.convert.stargate.in.filter=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.convert.stargate.in.filter.limit=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.convert.stargate.in.filter.smalltable.threshold=10485760 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.filter=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mapjoin.filter.autogen=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mappruning=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mappruning.debug=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.materialized.views.cache.type=LRU | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.maxinlistcount.threshold=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.maxjoincount.threshold=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.maxunioncount.threshold=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.approx.ndv=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.compatibility.log=0.6 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.cube.metacache=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.for.cube=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.for.naive.mv=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.ignore.mvquery.schema=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.join.rewriter.version=v2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.log.verbose=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.max.cached.mvs=500 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.merge.aggregate=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.pre.load.cube.number=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.pre.load.mv.number=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.pre.load.prior=cube | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.rewrite.greedy=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mbo.rewrite.scalar.subquery=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.merge.discardnull=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.mergecube=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.metastore.table.location.compatible=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.nls_sort=binary | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.non.correlated.subquery.ast.transform=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.nonnative.table.meta.refresh=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.notnull.audit=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.cbo.preanalyze=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.cbo.preanalyze.level=column | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.close.manually=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.resultfile.dir=/tmp/isoResultFile | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.offlineiso.showorgsqlline=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.onlineiso.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.onlineiso.withas.cache.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.onlineiso.withas.cache.maxnum=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.onlineiso.withas.filterppd.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimize.intersect.groupby.pushdown=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimize.joinreorder=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimize.joinreorder.bushy=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimize.joinreorder.outerinner=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimize.outerjoin.conversion=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimized.merge=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.optimizer.on=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.orderby.sample.limit=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.outer.limit.eliminate=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.parser.genselcol.lightway=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.parser.heuristic.join.reorder=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.permanent.udf.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.ppd.ice=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.predicate.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.queryPlan.compress=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.rebucketing.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.rewrite.escape.identifier=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.config.refresh=3000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.guardian.refresh=30000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.intelligent.algorithm=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.intelligent.algorithm.blacklist=SYSTEM | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.scheduler.priority= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.distinct.group.by.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.group.by.alias.support=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.non.group.by.support=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.occurrence.number.threshold=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.order.by.alias.support=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.select.list.cse.weight.threshold=5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.server2.support.dynamic.service.discovery=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.set.operation.commutative.law=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.simple.updel.optimize=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.singleinsert=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.skip.optimizer=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.smallfile.automerge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.smallfile.mergesize=31457280 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.sql.show.maxlength=1024 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.stats.ndv.error=20.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.stats.ndv.estimator=HLL | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.stats.ndv.relativesd=0.05 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.strict.evaluate=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.strict.subquery.check=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.subq.orderby.eliminate=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.subquery.join.condition.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.support.english.date.format=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.support.subquery.without.brackets=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.throw.zero.divisor.exception=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.torc.allow.rename=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.transactions.batchsize=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.udafdistinct.groupby.conversion=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.udf.compatible.with.oracle=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.udf.v2.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.ui.port=8888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.update=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.vectjoin.skipclone=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.whereinexists.semijoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.winfunc.max.partition.num=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.winfunc.predicate.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.winfunc.topk.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.withas.material=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.withas.resultcache.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | inceptor.withas.transform.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.aggregation.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.debugmode.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.jobexpire.maxtime=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.jobqueue.maxsize=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.metrics.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.sampling.rate=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.scope.maxsize=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.sequence.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | io.transwarp.messagehandler.sequence.maxsize=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.PersistenceManagerFactoryClass=org.datanucleus.api.jdo.JDOPersiste | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.ConnectionDriverName=com.mysql.jdbc.Driver | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.ConnectionPassword=password | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.ConnectionURL=jdbc:mysql://bireport2:3316,bireport3:3316,bi | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.ConnectionUserName=inceptoruser | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.DetachAllOnCommit=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.Multithreaded=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | javax.jdo.option.NonTransactionalRead=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | license.zookeeper.quorum=bireport1:2291,bireport2:2291,bireport3:2291 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapred.child.java.opts=-agentpath:/usr/lib/hadoop/bin/libagent.so -Xmx4096m | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapred.graph.reduce.tasks=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapred.minreduce.tasks=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.input.fileinputformat.input.dir.recursive=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.input.fileinputformat.split.maxsize=256000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.input.fileinputformat.split.minsize=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.input.fileinputformat.split.minsize.per.node=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.input.fileinputformat.split.minsize.per.rack=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.job.reduces=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.jobtracker.address=bireport2:8031,bireport3:8031 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.map.memory.mb=2048 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.reduce.speculative=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | mapreduce.task.partition=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.cache.inter.metrics=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.channel.queue.size=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.dropjob.when.clean.wal=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.enable.exactly.once=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.glk.flush.interval.seconds=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.groupby.incremental.enable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.hdfs.flush.interval.ms=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.hdfs.flush.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.infinitewindow.reduce.tasks=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.is.cube.application=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.checkpoint.interval=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.checkpoint.timeout=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.enable.auto.failover=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.enable.checkpoint=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.enable.wal.sink=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.job.failover.strategy=all | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.mapjoin.allow.update=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.mapjoin.update.interval.seconds=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.maponly.groupby=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.maxlag.on.disorder=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.metrics.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.multi.output.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.onheap.agg.size=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.ptf.auto.emit=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.ptf.emit.all.partitions=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.record.flush.size=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.result.auto.flush=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.shuffle.flush.interval=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.task.max.failures=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.update.window.reset.time=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.use.memorysort=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.use.ruleengine=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.buffer.max.number=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.complete.output=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.complete.output.update.ts=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.enable.auto.watermark=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.retract.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | morphling.window.updateouput.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | next.timeout.iterator.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | next.timeout.iterator.interval.rows=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | next.timeout.iterator.scheduler.period=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | next.timeout.iterator.timeout.period=120000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.allow.insecure.ports=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.dump.dir=/tmp/.hdfs-nfs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.mountd.port=4242 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.rtmax=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.server.port=2049 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | nfs.wtmax=1048576 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.aggr.serde=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.annotate.statistics=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.automerge.locality=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.batchsize=256 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.broadcast.join=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.broadcast.join.smalltable.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.broadcast.parallel.smalltable.collect=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.bucket.merge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.columnar.reportall=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.columnar.storage=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.compile.cache=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.compile.cache.size=40 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.crux.lookup.batch.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.crux.table.scan.engine.local=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.crux.table.scan.exception.limit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.crux.tradition.lookup.sortstyle=sort | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.dag=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.dd.local.mode.auto=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.disable.select.star=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.dynamic.partition.merge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.escape.encode=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.exec.mode=cluster | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.exec.treat.default.part.as.null=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.fastshuffle=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.filesystem.cache.disabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.furion.pool= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.graphsql.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.groupby.offheap=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.hdfs.filesystem.cache.disabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.int.runlength=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.iterator.fetchTask=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.join.batchsize=256 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.join.killable.threshold=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.join.nonequal.itermode=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.join.offheap=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.join.omitmismatch=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.fast.compute.parallelism=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.fast.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.fast.execute.before.fetch=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.fast.parallelism=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.holodesk.read.limit=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.holodesk.slice.size=5000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.job=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.job.debug=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.job.lineage.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.job.max.records=5000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.job.record.timeout.ms=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.lookupjoin.disable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.lookupjoin.lazyrdd=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.para.opt.ascluster=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.parallelism=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.skip.copy.conf=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.split=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.local.trie.key.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpar.mapjoin.hdfs=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.expfeature1=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.expfeature1.arg= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.lookupjoin.pushdown.limit=10000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.lookupjoin.v2=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.skewjoin.limit=1000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.localpara.timeout=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mapjoin.autoconvert=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mapjoin.partitionprune=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mergesort.compress.array.level=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mergesort.compress.spill=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mergesort.max.buffer.size=16777216 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.mergesort.max.output.filesize=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.metacache=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.metacache.level=none | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.metacache.server.maxsize=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.metacache.server.timeout.ms=3600000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.minmaxfilter.insert.delta.threshold=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.nested.transaction=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.num.parts.try.limit=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.groupby=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.intersect=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.mem=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.merge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.orc=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.torc.allowed=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.udf=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.o4.union=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.op.timestats.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.operator.rowcount.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.operator.tree.display=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.insert.single.file=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.insert.single.file.skip.select=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.merge.groupby=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.merge.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.parallel.shuffle.join=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.partial.groupby=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.partial.join=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.remove.dup.reducesink=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.runtime.cogroupjoin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.runtime.tablescan=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.optimization.value.fast.serde=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.orderby.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partial.fetch.size=25165824 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partition.automerge=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partition.mergesize=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partition.mergesize.mb=8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partition.table.cache=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.partition.table.cache.check.mod=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.pipeline.job=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.ppd=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.profiling=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.query.result.line.delim= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.query.result.serde.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.reader.dictfilter=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.reader.minmaxfilter=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.reader.minmaxfilter.torc.allowed=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.reader.rowfilter=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.result.paging=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.result.paging.autoclose=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.result.paging.record.batch.size=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.safety.size.single.entry=536870912 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.scheduler.desc.xml.file=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.scheduler.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.show.local.job=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.smalltable.bigendian=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.smalltable.exception.size=4294967296 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.smalltable.mapside.simple=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.smalltable.thread.work=67108864 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.smalltable.tradition.threshold=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.splits.reduce=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.analyze=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.dir=/tmp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.expect.interval=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.expect.max=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.hardlimit.interval=2000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.jstack.logger.hardlimit.max=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.print.console=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.sql.rewriter.impl= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.between.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.convert.failed.emptyrdd.return=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.debug.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.equal.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.equalorgreaterthan.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.equalorlessthan.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.geo.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.greaterthan.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.in.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.isnotnull.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.isnull.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.lessthan.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.like.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.notequal.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.notin.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.notlike.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.pushdown.only.range=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.range.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.script.convert.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.search.script.udf.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filter.with.node=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filterjoin.collect.joinkey.eachnode.max=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filterjoin.collect.joinkey.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filterjoin.pushdown.filter.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.filterjoin.without.filter.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.groupby.udf.push.down=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.infilter.display.length.max=10 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.stargate.orderby.linguistic.sort.type.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.subquery.calculate.partial=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.subquery.partitionprune=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topk.lazyserde=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topo.check=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topo.depth.limit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topo.mapred.limit=1000000000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topo.stage.limit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.topo.tasks.limit=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.transaction.readcommitted=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.transaction.readuncommitted=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.trie.key=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.trie.keychunk.mb=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.trie.node.max=20480000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.using.stats=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.vector.size=1024 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.visual.operator=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.visual.operator.local=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | ngmr.windrunner.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | opt=off | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.bloom.filter.dist.scale=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.bloom.filter.fpp=0.05 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.columnreader=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.auto.analyze=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.blacklist.threshold=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.kerberos.conf=/etc/krb5.conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.service.check.interval=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.service.provider=metastore | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.thread.check.interval=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compact.without.lock=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compactor.initiator.on=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.compactor.worker.threads=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.crud.nonexistent.part.opt=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.crud.optimized=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.crud.optimized.reader=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.ctc.in.conf=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.independent.writer=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.less.ctc=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.merge.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.mergeinsert.inheap.rows=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.minor.compact.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.skip.flush.length=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | orc.txn.schema.cache.size=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | output.formatter=org.apache.hadoop.hive.ql.exec.FetchFormatter$ThriftFormatt | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | output.protocol=6 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | parquet.memory.pool.ratio=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | partition.crud.validate.check.and.cast=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.cache.output=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.catch.hive.exception=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.check.driver.env=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.client.dialect=oracle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.compile.dml.check.semantic=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.cursor.local.job.record.timeout.weight=100 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.linkhook.throw.exceptions=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.optimize.dml.precompile=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.optimize.dml.precompile.deopt=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.process.strict=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.reserve.create.force.ifnotexists=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.reserve.in.upgrade.mode=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.runtime.profile=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.server.dialect=oracle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.show.sqlresults=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | plsql.use.slash=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | query.engine=inceptor | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | query.lang=sql | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.autoack=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.autodelete=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.durable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.exclusive=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.internal=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.message.buffersize=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.password=guest | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.port=5672 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.username=guest | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rabbitmq.virtualhost=/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | range.partition.crud.check.last.range=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | range.partition.insert.check.last.range=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.adjustthreadpoolnumsthreshold=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumeconcurrentlymaxspan=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumefromwhere=first | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumemessagebatchmaxsize=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumertype=push | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumethreadmax=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.consumethreadmin=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.message.buffersize=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.message.pullmaxnums=32 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.pullbatchsize=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.pullthresholdforqueue=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rocketmq.pushlistenertype=order | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | rubik.persistence.database=rubik1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | server.dialect=oracle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | server.dialect.parser.oracle=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | server.dialect.td.varchar2.trim.end=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | silent=off | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | slipstream.commander.microbatch.optimize=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.logging.dir=/tmp/logging/inceptor | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.logging.enable=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.morphling.taskstate.checkpoint.directory.ms=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.streaming.blockInterval=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.streaming.blockQueueSize=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | spark.streaming.receiver.maxRate=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | standalone.compact.use.mapreduce=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.advance.filter.generator=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.andor.filter.convert=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.async.fetch=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.async.fetch.container.size=50000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.customized.default.filter.selectivity=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.customized.max.like.filter.selectivity=0.2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.customized.range.filter.selectivity=0.33333334 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.debug.log=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dimension.deduplicate=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dimension.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dispatcher=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dynamic.partition.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dynamic.partition.retry.interval.ms=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.dynamic.partition.retry.max.times=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.filter.pushdown.selectivity.upper.bound=1.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.filter.selectivity.cleanedby.storage=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.filter.selectivity.estimated=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.filter.selectivity.judge.pushdown=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.get.stat.from.storage=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.get.stat.from.tblproperties=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.batch.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.queue.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.queue.timeout.ms=180000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.sortkey=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.glk.parallel.scan.thread.num=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.global.lookup.join=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.global.lookup.join.batchsize=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.global.lookup.join.disable.quietly=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.global.lookup.join.storage.shuffle=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.limit.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.lookup.join.batch=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.lookup.join.batchsize=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.lookup.join.enable.different.type=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.lookupjoin.estimatedsize.fetch.timeout.ms=300 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.lookupjoin.joinorder=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.local.rdd.multi.partition=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.metrics.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.orderby.pushdown=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.parallel.getrdd.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.parallel.getrdd.max.thread.per.tsop=50 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.parallel.getrdd.min.partition.size=20 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.parallel.getrdd.poolsize=150 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.parallel.getrdd.wait.interval.ms=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.partition.without.limit.orderby.pushdown=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.ppd.dblink=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.selectivity.conf.read.tblproperties=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stargate.selectivity.override.range.pushdown=0.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stellardb.unsupported.or.filter.throw.exception=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.allow.dirtydata=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.application.name=default | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.batch.duration.ms=2000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.driver.enable.autofailover=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.driver.ha.node=/InceptorServer2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.number.receivers=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.stderr.reporter.enabled=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | stream.stderr.reporter.prefix=reporter: | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.backpressure.max.pendingJobs=2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.debug.mode=SILENCE | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.enable.backpressure.receiver=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.enable.hdfs.batchflush=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.eventtime.maxlag.on.disorder=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.eventtime.slideduration=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.eventtime.zerotime=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.hdfs.batchflush.interval.ms=60000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.hdfs.batchflush.size=100000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.infinitewindow.numreducers=8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.max.running.sql=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.max.running.task=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.use.eventmode=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.use.eventtime=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | streamsql.use.optimize.serde=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | studio.dao.factory=io.transwarp.studio.persistence.dao.dummy.DummyDaoFactory | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system.task.pool.name=system | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | text.file.enable.splitable=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | transaction.type=none | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | union.local.parallel.batch.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | union.local.parallel.queue.size=1000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | union.local.parallel.run=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | union.local.parallel.thread.safety.num=200 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | use.hyperdrive=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | use.ngmr=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | use.ngmr.cbo=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | use.paladin=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | use.plsql.timeout.operation=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | zookeeper.session.timeout=180000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | zookeeper.znode.parent=/hyperbase1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:COMPACTOR_ID=compactor_inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:COMPACTOR_PID_FILE=/var/run/inceptor//compactor.pid | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:COMPACTOR_PORT=9918 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:DATADIR=/var/transwarp/data | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:DATA_DIR=/var/transwarp/data | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:DATA_DIRS=/data | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:DEFAULT_CONTAINER_EXECUTOR=TRUE | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:EXECUTOR_ID_PATH=/inceptor1/executorID | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:EXTRA_DRIVER_OPTS= -Dinceptor.leviathan.studio.host=10.50.254.45 -Dince | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:EXTRA_EXECUTOR_OPTS= -Djava.security.auth.login.config=/etc/inceptor1/c | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:EXTRA_METASTORE_OPTS= -Djava.security.auth.login.config=/etc/inceptor1/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:GUARDIAN_PLUGINS_CONF_DIR=/usr/lib/guardian-plugins/templates | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:GUARDIAN_PLUGINS_HOME=/usr/lib/guardian-plugins | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HADOOP_COMMON_HOME=/usr/lib/hadoop | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HADOOP_CONF_DIR=/etc/hdfs1/conf:/etc/yarn1/conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HADOOP_HOME=/usr/lib/hadoop | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HBASE_CONF_DIR=/etc/hyperbase1/conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HBASE_HOME=/usr/lib/hbase | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HIVE_METASTORE_SERVER=bireport2,bireport3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HIVE_METASTORE_URIS=thrift://bireport2,bireport3:9083 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HIVE_PORT=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HIVE_SERVER2=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HOME=/root | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:HOSTNAME=bireport2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_COMPACTOR_MEMORY=4096 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_CONF_DIR=/etc/inceptor1/conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_EXECUTOR_COUNT=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_EXECUTOR_MEMORY=32000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_HOME=/usr/lib/inceptor | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_IDENT_STRING=bireport2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_LICENSE_ZOOKEEPER_QUORUM= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_LOG_DIR=/var/log/inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_METASTORE_MEMORY=4096 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_PID_DIR=/var/run/inceptor/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_PLUGINS=/usr/lib/transwarp/plugins | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_PROFILER_MEMORY=8192 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_SCRIPTS=/usr/lib/transwarp/scripts | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_SERVER_MEMORY=8192 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:INCEPTOR_UI_PORT=8888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVA7_HOME=/usr/java/jdk1.7.0_71/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVA8_HOME=/usr/java/jdk1.8.0_25 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVAX_JDO_OPTION_CONNECTIONURL=jdbc:mysql://bireport1:3316,bireport2:331 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVAX_JDO_OPTION_CONNECTION_PASSWORD=password | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVAX_JDO_OPTION_CONNECTION_USERNAME=inceptoruser | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JAVA_HOME=/usr/java/jdk1.8.0_25 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JMXEXPORTER_ENABLED=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:JMX_EXPORTER_JAR=/usr/lib/jmx_exporter/jmx_prometheus_javaagent-0.2.0.ja | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KRB_ENABLE=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_PORT=tcp://10.10.10.1:443 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_PORT_443_TCP=tcp://10.10.10.1:443 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_PORT_443_TCP_ADDR=10.10.10.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_PORT_443_TCP_PORT=443 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_PORT_443_TCP_PROTO=tcp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_SERVICE_HOST=10.10.10.1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_SERVICE_PORT=443 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:KUBERNETES_SERVICE_PORT_HTTPS=443 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:LANG=en_US.utf-8\nLC_ALL=en_US.UTF-8\n | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:LC_ALL=en_US.UTF-8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:LOGDIR=/var/transwarp/logs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:LOGNAME=hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:LOG_DIR=/var/transwarp/logs | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:MASTER=docker | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:METASTORE_ID=metastore_inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:METASTORE_PID_FILE=/var/run/inceptor//metastore.pid | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:METASTORE_PORT=9083 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:MYSQL_DATADIR=/var/transwarp/mysql/data | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:MYSQL_LOGDIR=/var/log/mysql | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:MYSQL_SERVER_PORT=bireport1:3316,bireport2:3316,bireport3:3316 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:NGMR_CACHE_SIZE=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:NGMR_EXECUTORS_PERJOB=1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:NGMR_EXECUTOR_PID_FILE=/var/run/inceptor//ngmr-executor.pid | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:NGMR_PID_FILE=/var/run/inceptor//ngmrserver.pid | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:PATH=/usr/java/jdk1.8.0_25/bin:/usr/java/jdk1.8.0_25/bin:/usr/java/jdk1. | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:PROFILER_ID=profiler_inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:PROFILER_PID_FILE=/var/run/inceptor//profiler.pid | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:PROFILER_PORT=9093 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:PWD=/home/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SCALA_HOME=/usr/lib/inceptor/lib | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SHLVL=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SOCKETDIR=/var/run/hadoop-common | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_CORES=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_DRIVER_ADDR=bireport2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_DRIVER_PORT=51888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_FASTDISK_DIR=/vdir/mnt/ramdisk/ngmr | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_JAR=/usr/lib/inceptor/lib/spark-core_2.10-1.1.0-transwarp.jar | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_LIBRARY_PATH=/usr/lib/hadoop/lib/native | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_LOCAL_DIR=/vdir/BIreport/hadoop/ngmr/inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SPARK_YARN_APP_JAR=/usr/lib/inceptor/inceptor_2.10-1.1.0-transwarp.jar | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SUDO_COMMAND=/bin/sh -c cd /home/hive; /bin/hive-inceptor.sh | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SUDO_GID=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SUDO_UID=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:SUDO_USER=root | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TDH_SCRIPT_DIR=/bin | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TERM=unknown | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_DATA_HOME=/var/transwarp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_DIR=/var/transwarp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_HOME=/usr/lib/transwarp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_SCRIPTS=/usr/lib/transwarp/scripts | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_SCRIPT_HOME=/usr/lib/transwarp/scripts | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_ZOOKEEPER_PORT=2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:TRANSWARP_ZOOKEEPER_QUORUM=bireport1,bireport2,bireport3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:USER=hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:USERNAME=hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:ZOOKEEPER_CONF=/etc/zookeeper/conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:ZOOKEEPER_HOME=/usr/lib/zookeeper | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:_=/usr/java/jdk1.8.0_25/bin/java | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | env:password=123 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:awt.toolkit=sun.awt.X11.XToolkit | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:class.default.serializer= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:file.encoding=UTF-8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:file.encoding.pkg=sun.io | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:file.separator=/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:hive.log.dir=/var/log/inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:hive.log.file=hive-server2.log | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.executorID.zkPath=/inceptor1/executorID | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.executorID.zkPort=2181 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.executorID.zkServer=bireport1,bireport2,bireport3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.executorID.zkTimeout=10000 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.leviathan.studio.host=10.50.254.45 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.leviathan.studio.http.port=4040 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.leviathan.studio.name=receiver | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.leviathan.studio.port=60606 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:inceptor.leviathan.studio.test.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.awt.printerjob=sun.print.PSPrinterJob | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.class.path=:/usr/lib/inceptor/inceptor-engine-8.0.2-tests.jar:/u | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.class.version=52.0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.endorsed.dirs=/usr/java/jdk1.8.0_25/jre/lib/endorsed | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.ext.dirs=/usr/java/jdk1.8.0_25/jre/lib/ext:/usr/java/packages/li | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.home=/usr/java/jdk1.8.0_25/jre | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.io.tmpdir=/tmp | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.library.path=/usr/lib/hadoop/lib/native | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.net.preferIPv4Stack=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.runtime.name=Java(TM) SE Runtime Environment | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.runtime.version=1.8.0_25-b17 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.security.auth.login.config=/etc/inceptor1/conf/jaas.conf | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.specification.name=Java Platform API Specification | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.specification.vendor=Oracle Corporation | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.specification.version=1.8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vendor=Oracle Corporation | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vendor.url=http://java.oracle.com/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vendor.url.bug=http://bugreport.sun.com/bugreport/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.version=1.8.0_25 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.info=mixed mode | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.name=Java HotSpot(TM) 64-Bit Server VM | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.specification.name=Java Virtual Machine Specification | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.specification.vendor=Oracle Corporation | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.specification.version=1.8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.vendor=Oracle Corporation | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:java.vm.version=25.25-b02 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:line.separator= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:ngmr.exec.mode=cluster | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:ngmr.task.pipeline=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:ngmr.task.pipeline.start.fraction=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:ngmr.task.pipeline.task.timeout.ms=-1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:os.arch=amd64 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:os.name=Linux | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:os.version=3.10.0-693.el7.x86_64 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:path.separator=: | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:shark.checkpoint.dir= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.akka.threads=8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.cleaner.ttl=14400 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.driver.host=bireport2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.driver.port=51888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.driver.portfixed= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.executors.expect.count=3 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.fastdisk.dir=/vdir/mnt/ramdisk/ngmr | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.guardian.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.kryoserializer.buffer.mb=4 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.local.dir=/vdir/BIreport/hadoop/ngmr/inceptor1 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.rdd.compress=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.storage.fastdiskFraction=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.storage.memoryFraction=0.5 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.ui.guardian.enabled=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.ui.port=8888 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:spark.ui.show.context.default=false | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.arch.data.model=64 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.boot.class.path=/usr/java/jdk1.8.0_25/jre/lib/resources.jar:/usr/ | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.boot.library.path=/usr/java/jdk1.8.0_25/jre/lib/amd64 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.cpu.endian=little | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.cpu.isalist= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.io.unicode.encoding=UnicodeLittle | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.java.command=io.transwarp.inceptor.InceptorServer2 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.java.launcher=SUN_STANDARD | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.jnu.encoding=UTF-8 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.management.compiler=HotSpot 64-Bit Tiered Compilers | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.net.inetaddr.ttl=60 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.nio.ch.bugLevel= | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:sun.os.patch.level=unknown | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:transwarp.io.netty.noKeySetOptimization=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:transwarp.io.netty.noUnsafe=true | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:transwarp.io.netty.recycler.maxCapacityPerThread=0 | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.country=US | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.dir=/home/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.home=/home/hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.language=en | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.name=hive | +------------------------------------------------------------------------------+ | | +------------------------------------------------------------------------------+ | system:user.timezone=Asia/Shanghai | +------------------------------------------------------------------------------+