HDInsightHiveQueryAppStats

Hive Query Metrics emitted from the YARN Timeline Server.

Table attributes

Attribute	Value
Resource types	microsoft.hdinsight/clusters
Categories	Azure Resources
Solutions	LogManagement
Basic log	No
Ingestion-time transformation	No
Sample Queries	-

Columns

Column	Type	Description
_BilledSize	real	The record size in bytes
ClientIpAddress	string	The query client's IP address.
ClusterName	string	Name of cluster.
ClusterType	string	Type of cluster (e.g. LLAP or Hadoop).
CorrelationId	string	The ID for correlated events. Can be used to identify correlated events between multiple tables.
Domain	string	The domain associated with the query.
Entity	string	Name of the query's entity.
EntityType	string	The type of the query's entity.
ExecutionMode	string	The execution mode of the query.
HiveInstanceType	string	The type of hive instance running the query.
HostName	string	Name of host where log was emitted.
_IsBillable	string	Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
IsMapReduce	bool	True if the query is a MapReduce query.
IsTez	bool	True if the query is a Tez query.
MetricName	string	Name of the metric for the record (e.g. AppsCompleted, AppsKilled, AppsFailed , etc).
MetricValue	real	Value of metric in the record.
OperationName	string	The operation associated with log record.
QueryCompletionTime	long	Time that query was completed.
QuerySubmissionTime	long	Time that query was submitted.
Queue	string	The queue the query was served from.
RequestUser	string	The client user that submitted the request.
_ResourceId	string	A unique identifier for the resource that the record is associated with
SessionId	string	The session ID of the query.
SourceSystem	string	The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
_SubscriptionId	string	A unique identifier for the subscription that the record is associated with
TablesRead	string	The tables read by the query.
Tags	dynamic	Information about the record. For example a record may be tagged with 'yarn' if it is in the yarn context.
TenantId	string	The Log Analytics workspace ID
ThreadName	string	The name of the thread running the query.
TimeGenerated	datetime	The timestamp (UTC) of when the log was generated.
Type	string	The name of the table
User	string	The user of the Hive instance executing the query.