gistfile1.txt

{hive.server.tcp.keepalive=true, lens.query.enable.mail.notify=false, lens.server.statistics.warehouse.dir=hdfs://192.168.138.164:8020/user/hive/warehouse, lens.server.drivers=org.apache.lens.driver.hive.HiveDriver,org.apache.lens.driver.jdbc.JDBCDriver, hive.server2.log.redirection.enabled=false, hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat, lens.query.output.enable.compression=true, mapred.job.name=60dd690f-2365-43b7-96d6-2e03da8b9a3a, lens.query.hdfs.output.path=hdfsout, lens.server.metastore.service.impl=org.apache.lens.server.metastore.CubeMetastoreServiceImpl, lens.cube.query.fail.if.data.partial=false, lens.server.user.resolver.propertybased.filename=/path/to/propertyfile, hive.metastore.batch.retrieve.table.partition.max=500, lens.query.result.size.format.threshold=10737418240, lens.server.user.resolver.ldap.search.filter=(&(objectClass=user)(sAMAccountName=%s)), lens.server.servicenames=session,query,metastore,scheduler,quota, lens.server.serverMode.ws.filter.impl=org.apache.lens.server.ServerModeFilter, lens.server.quota.ws.resource.impl=org.apache.lens.server.quota.QuotaResource, lens.driver.hive.priority.ranges=HIGH,7,NORMAL,30,LOW,90,VERY_LOW, hive.metastore.batch.retrieve.max=100, lens.server.db.jdbc.pass=root, lens.server.enable.graphite.metrics=false, lens.server.user.resolver.ldap.intermediate.db.insert.sql=insert into user_department (username, department, expiry) values (?, ?, ?), lens.cube.query.disable.auto.join=false, mapreduce.job.queuename=yoda_others_high, lens.query.result.parent.dir=hdfs://192.168.138.164:8020/tmp/lensreports, hive.task.progress=true, lens.driver.hive.priority.partition.weight.daily=0.75, lens.server.ui.enable.caching=true, lens.server.session.timeout.seconds=86400, hive.cube.disable.auto.join=false, lens.server.mail.smtp.connectiontimeout=15000, lens.server.user.resolver.ldap.bind.dn=CN=yoda-admin,ou=service-account,ou=inmobi-service-account,dc=mkhoj,dc=com, lens.server.statistics.store.class=org.apache.lens.server.stats.store.log.LogStatisticsStore, lens.server.domain=inmobi.com, lens.server.mode=OPEN, lens.server.scheduler.service.impl=org.apache.lens.server.scheduler.QuerySchedulerServiceImpl, lens.server.user.resolver.type=CUSTOM, lens.query.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec, lens.query.add.insert.overwrite=true, lens.cube.query.time.range.writer.class=org.apache.lens.cube.parse.AbridgedTimeRangeWriter, lens.server.max.finished.queries=100, cube.query.fail.if.data.partial=true, lens.cube.query.nonexisting.partitions={"summary1":["it:[2014-11-24-20-00-00, 2014-11-24-21-00-00)"]}, lens.server.user.resolver.ldap.fields=department, hive.server2.thrift.client.connect.retry.limit=3, mapreduce.job.name=60dd690f-2365-43b7-96d6-2e03da8b9a3a, lens.server.enable.resource.method.metering=true, lens.server.user.resolver.ldap.intermediate.db.delete.sql=delete from user_department where username=?, lens.query.enable.persistent.resultset.indriver=false, lens.server.appevent.ws.listener.impl=org.apache.lens.server.LensApplicationListener, lens.server.user.resolver.ldap.intermediate.db.query=select department from user_department where username=? and expiry>?, lens.server.mail.from.address=blah@company.com, lens.driver.hive.priority.partition.weight.hourly=1.0, lens.cube.query.promote.groupby.toselect=true, lens.server.ws.listenernames=appevent, lens.server.mail.host=mail-host.company.com, hive.server2.thrift.port=10000, lens.driver.hive.connection.class=org.apache.lens.driver.hive.RemoteThriftConnection, lens.server.recover.onrestart=true, hive.server2.authentication.ldap.security.protocol=ssl, hive.server2.thrift.client.retry.delay.seconds=1, lens.server.user.resolver.ldap.search.base=cn=users,dc=mkhoj,dc=com, lens.cube.query.process.time.partition.column=pt, lens.server.mail.smtp.timeout=30000, lens.server.ui.static.dir=webapp/lens-server/static, lens.query.result.split.multiple=true, lens.cube.query.replace.timedim=true, hive.server2.thrift.bind.host=localhost, hive.metastore.client.socket.timeout=300, lens.server.statistics.db=lensstats, lens.server.enable.console.metrics=false, lens.server.driver.selector.class=org.apache.lens.server.api.driver.MinQueryCostSelector, lens.cube.query.join.type=LEFTOUTER, lens.client.dbname=yoda, lens.server.db.validation.query=select 1, mapred.job.queue.name=yoda_others_high, lens.server.persist.location=hdfs://192.168.138.164:8020/tmp/lensserver, lens.cube.query.promote.select.togroupby=true, lens.query.enable.metrics.per.query=false, lens.server.metastore.ws.resource.impl=org.apache.lens.server.metastore.MetastoreResource, hive.server2.authentication=NONE, lens.server.restart.enabled=true, lens.server.enable.csv.metrics=false, lens.session.cluster.user=yoda, lens.driver.hive.priority.partition.weight.monthly=0.5, lens.server.metrics.reporting.period=10, hive.server2.async.exec.threads=5, lens.query.result.output.dir.format=ROW FORMAT SERDE 'org.apache.lens.lib.query.CSVSerde' STORED AS TEXTFILE, lens.server.ws.resourcenames=session,metastore,query,quota,scheduler,index, lens.server.user.resolver.custom.class=com.inmobi.yoda.user.CustomLDAPConfigLoader, lens.server.base.url=http://192.168.138.164:9999/lensapi/, cube.query.promote.select.togroupby=true, hive.server2.thrift.client.retry.limit=3, lens.client.user.name=arshad.matin, lens.server.user.resolver.ldap.url=ldaps://mk-ad-1.mkhoj.com:636/, lens.query.enable.persistent.resultset=true, lens.server.query.service.impl=org.apache.lens.server.query.QueryExecutionServiceImpl, hive.metastore.connect.retries=5, hive.metastore.uris=thrift://localhost:9083, lens.query.output.charset.encoding=UTF-8, lens.server.mail.port=25, lens.server.quota.service.impl=org.apache.lens.server.quota.QuotaServiceImpl, lens.server.ws.filternames=authentication,consistentState,serverMode, lens.query.output.write.footer=true, lens.query.result.split.multiple.maxrows=100000, lens.cube.query.pick.lightest.fact.first=true, lens.server.estimate.pool.max.threads=100, lens.server.ui.enable=false, lens.server.db.driver.name=com.mysql.jdbc.Driver, lens.server.session.ws.resource.impl=org.apache.lens.server.session.SessionResource, hive.metastore.client.connect.retry.delay=1, lens.server.service.provider.factory=org.apache.lens.server.ServiceProviderFactoryImpl, lens.server.estimate.pool.min.threads=3, lens.server.session.expiry.service.interval.secs=3600, lens.server.query.ws.resource.impl=org.apache.lens.server.query.QueryServiceResource, lens.server.user.resolver.db.query=select clusteruser, queue from (select ifnull(clusteruser,'yoda') as clusteruser, ifnull(queue,'yoda_others') as queue,1 as pref from user_config_table where department=? union select 'yoda', 'yoda_others', 0) temp order by pref desc limit 1;, lens.server.session.service.impl=org.apache.lens.server.session.HiveSessionService, lens.server.ui.base.uri=http://192.168.138.164:19999/, lens.server.snapshot.interval=300000, lens.server.state.persist.out.stream.buffer.size=1048576, lens.server.estimate.timeout.millis=300000, lens.driver.hive.calculate.priority=true, mapred.job.priority=HIGH, hive.server.read.socket.timeout=60, lens.server.user.resolver.db.keys=lens.session.cluster.user,mapred.job.queue.name, mapreduce.job.priority=HIGH, hive.server2.thrift.client.user=dataqa, lens.server.metrics.csv.directory.path=metrics/, lens.server.statistics.log.rollover.interval=3600000, lens.server.index.ws.resource.impl=org.apache.lens.server.IndexResource, lens.driver.hive.hs2.connection.expiry.delay=600000, cube.query.promote.groupby.toselect=true, mapred.job.queuename=yoda_others_high, lens.server.db.jdbc.user=root, lens.server.db.jdbc.url=jdbc:mysql://localhost/lens, lens.server.database.resource.dir=file:///tmp/lens/resources, lens.server.query.state.logger.enabled=true, lens.query.output.file.extn=.csv, lens.cube.query.driver.supported.storages=local,uh1,uh1_pie, lens.server.scheduler.ws.resource.impl=org.apache.lens.server.scheduler.ScheduleResource, lens.server.enable.ganglia.metrics=false, lens.server.estimate.pool.keepalive.millis=60000, lens.server.ws.featurenames=multipart, lens.server.consistentState.ws.filter.impl=org.apache.lens.server.ConsistentStateFilter, lens.server.user.resolver.ldap.bind.password=Y0da@dmin, lens.server.authentication.ws.filter.impl=org.apache.lens.server.AuthenticationFilter, lens.session.loggedin.user=arshad.matin, lens.server.multipart.ws.feature.impl=org.glassfish.jersey.media.multipart.MultiPartFeature, hive.cube.disable.aggregate.resolver=false, hive.metastore.failure.retries=3, lens.query.result.output.serde=org.apache.lens.lib.query.CSVSerde, lens.cube.query.disable.aggregate.resolver=false, lens.query.output.write.header=true}