I am trying to Estimate the time required by queries from simple to complex in Impala and using the Hue UI. Will it be possible to know the time needed to complete the query through the UI.
相关问题
- Spark on Yarn Container Failure
- enableHiveSupport throws error in java spark code
- spark select and add columns with alias
- Unable to generate jar file for Hadoop
-
hive: cast array
> into map
相关文章
- Java写文件至HDFS失败
- mapreduce count example
- Could you give me any clue Why 'Cannot call me
- Hive error: parseexception missing EOF
- Exception in thread “main” java.lang.NoClassDefFou
- ClassNotFoundException: org.apache.spark.SparkConf
- How can I configure the maven shade plugin to incl
- How was the container created and how does it work
HUE has no such feature in its present version.
You can design a script like:
echo Current time $(date '+%T')
impala-shell -f <> OR impala-shell -q <>
echo Current time $(date '+%T')
and execute the script
If you have access to deamon Web UI (default port 25000) you can navigate to /queries and choose profile for the query you are interested in. Then look for the query time line.
Impala or Hive only provides a general estimate of progress.
Hue could try to display an end time by extrapolating the start time by the current progress. Feel free to follow https://issues.cloudera.org/browse/HUE-1219.
Although it seems to be not possible with Hue UI but in Command Shell its the last result line whenever query is completed.