Database Reference
In-Depth Information
Listing 13-7.
hive-site.xml
<property>
<name>hive.log.dir</name>
<value>c:\apps\dist\hive-0.11.0.1.3.0.1-0302\logs</value>
</property>
Listing 13-7 shows the default location of the log file for Hive which is the
\logs
folder. The log file is created with
the name of
hive.log
.
Log Files
Any
Data Definition Language
(
DDL
) or
Data Manipulation Language
(
DML
) commands are logged in the log files.
For example, if you execute an HQL,
CREATE DATABASE TEST
and it gets created successfully, you should see similar
entries in your
hive.log
file as shown in Listing 13-8.
Listing 13-8.
hive.log
2013-11-15 11:56:49,326 INFO ql.Driver (PerfLogger.java:PerfLogBegin(100))
- <PERFLOG method=Driver.run>
2013-11-15 11:56:49,326 INFO ql.Driver (PerfLogger.java:PerfLogBegin(100))
- <PERFLOG method=TimeToSubmit>
2013-11-15 11:56:49,326 INFO ql.Driver (PerfLogger.java:PerfLogBegin(100))
- <PERFLOG method=compile>
2013-11-15 11:56:49,327 INFO parse.ParseDriver (ParseDriver.java:parse(179))
- Parsing command: create database test
2013-11-15 11:56:49,329 INFO parse.ParseDriver (ParseDriver.java:parse(197))
- Parse Completed
2013-11-15 11:56:49,331 INFO ql.Driver (Driver.java:compile(442))
- Semantic Analysis Completed
2013-11-15 11:56:49,332 INFO ql.Driver (Driver.java:getSchema(259))
- Returning Hive schema: Schema(fieldSchemas:null, properties:null)
2013-11-15 11:56:49,332 INFO ql.Driver (PerfLogger.java:PerfLogEnd(127))
- </PERFLOG method=compile start=1384516609326 end=1384516609332 duration=6>
2013-11-15 11:56:49,332 INFO ql.Driver (PerfLogger.java:PerfLogBegin(100))
- <PERFLOG method=Driver.execute>
2013-11-15 11:56:49,333 INFO ql.Driver (Driver.java:execute(1066))
-
Starting command: create database test
2013-11-15 11:56:49,333 INFO ql.Driver (PerfLogger.java:PerfLogEnd(127))
- </PERFLOG method=TimeToSubmit start=1384516609326 end=1384516609333 duration=7>
2013-11-15 11:56:49,871 INFO ql.Driver (PerfLogger.java:PerfLogEnd(127))
- </PERFLOG method=Driver.execute start=1384516609332 end=1384516609871 duration=539>
2013-11-15 11:56:49,872 INFO ql.Driver
(SessionState.java:printInfo(423))
- OK
2013-11-15 11:56:49,872 INFO ql.Driver (PerfLogger.java:PerfLogBegin(100))
- <PERFLOG method=releaseLocks>
2013-11-15 11:56:49,872 INFO ql.Driver (PerfLogger.java:PerfLogEnd(127))
- </PERFLOG method=releaseLocks start=1384516609872 end=1384516609872 duration=0>
2013-11-15 11:56:49,872 INFO ql.Driver (PerfLogger.java:PerfLogEnd(127))
- </PERFLOG method=Driver.run start=1384516609326 end=1384516609872 duration=546>
2013-11-15 11:56:49,873 INFO CliDriver
(SessionState.java:printInfo(423))
