2018-01-18T15:55:15,637 INFO  [HiveServer2-Handler-Pool: Thread-37([])]:
thrift.ThriftCLIService (ThriftCLIService.java:OpenSession(317)) - Client
protocol version: HIVE_CLI_SERVICE_PROTOCOL_V7
2018-01-18T15:55:15,648 INFO  [HiveServer2-Handler-Pool: Thread-37([])]:
session.SessionState (SessionState.java:createPath(749)) - Created HDFS
directory: /tmp/hive/a8197zz/67272380-f3e9-40da-8e8e-a209c05eb4fe
2018-01-18T15:55:15,650 INFO  [HiveServer2-Handler-Pool: Thread-37([])]:
session.SessionState (SessionState.java:createPath(749)) - Created local
directory: /mnt/tmp/hive/67272380-f3e9-40da-8e8e-a209c05eb4fe
2018-01-18T15:55:15,653 INFO  [HiveServer2-Handler-Pool: Thread-37([])]:
session.SessionState (SessionState.java:createPath(749)) - Created HDFS
directory: /tmp/hive/a8197zz/67272380-f3e9-40da-8e8e-
a209c05eb4fe/_tmp_space.db

cat hive-server2.log | grep 's3|user|query'

2018-01-18T16:20:39,464 WARN  [67272380-f3e9-40da-8e8e-a209c05eb4fe HiveServer2-Handler-Pool: Thread-37([])]: util.CurrentUserGroupInformation (CurrentUserGroupInformation.java:getGroupNameFromUser(52)) - user a8197zz (auth:PROXY) via hive (auth:SIMPLE) has no primary groupName, setting groupName to be a8197zz.
2018-01-18T16:23:25,389 INFO  [HiveServer2-Background-Pool: Thread-63([])]: ql.Driver (Driver.java:execute(1735)) - Executing command(queryId=hive_20180118162325_5ad8be3f-80e7-468d-bb47-1bdc2d2fb624): select * from pfeevent limit 5
2018-01-18T16:23:25,393 INFO  [HiveServer2-Background-Pool: Thread-63([])]: ql.Driver (Driver.java:execute(2050)) - Completed executing command(queryId=hive_20180118162325_5ad8be3f-80e7-468d-bb47-1bdc2d2fb624); Time taken: 0.004 seconds
2018-01-18T16:23:25,972 INFO  [67272380-f3e9-40da-8e8e-a209c05eb4fe HiveServer2-Handler-Pool: Thread-49([])]: s3n.S3NativeFileSystem (S3NativeFileSystem.java:open(1210)) - Opening 's3://3m-his-dev-cayuga/Demo-Enterprise/TrustedZone/Published/Enrichment/Core/PFE/PFEEvent/part-00000-f4340808-220a-424c-ba67-3f2383ea42ea-c000.snappy.parquet' for reading