You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Rohit Choudhary (JIRA)" <ji...@apache.org> on 2015/08/07 14:44:46 UTC
[jira] [Updated] (AMBARI-12671) Progress bar in Hive view shows
100% but job is still running
[ https://issues.apache.org/jira/browse/AMBARI-12671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rohit Choudhary updated AMBARI-12671:
-------------------------------------
Description:
PROBLEM: Progress bar in Hive view shows 100% but job is still running
IMPACT: confusion to customers and don't know if it ran or not hence critical since it affects user experience.
-download this file on your machine https://s3.amazonaws.com/hw-sandbox/tutorial1/NYSE-2000-2001.tsv.gz
-now go to ambari hive views and execute to create the table:
CREATE TABLE `nyse_stocks`(
`exchange` string,
`stock_symbol` string,
`date` string,
`stock_price_open` float,
`stock_price_high` float,
`stock_price_low` float,
`stock_price_close` float,
`stock_volume` bigint,
`stock_price_adj_close` float)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-now upload file as mentioned above, using the files browser view and place it in the newly created path:
/apps/hive/warehouse/nyse_stocks/
-go to hive view and execute select count(*) from nyse_stocks;
it should error
then execute it again after you should see the attached screenshot.
was:
PROBLEM: Progress bar in Hive view shows 100% but job is still running
IMPACT: confusion to customers and don't know if it ran or not hence critical since it affects user experience.
-now go to ambari hive views and execute to create the table:
CREATE TABLE `nyse_stocks`(
`exchange` string,
`stock_symbol` string,
`date` string,
`stock_price_open` float,
`stock_price_high` float,
`stock_price_low` float,
`stock_price_close` float,
`stock_volume` bigint,
`stock_price_adj_close` float)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-now upload attached in the bug, using the files browser view and place it in the newly created path:
/apps/hive/warehouse/nyse_stocks/
-go to hive view and execute select count(*) from nyse_stocks;
it should error
then execute it again after you should see the attached screenshot.
> Progress bar in Hive view shows 100% but job is still running
> -------------------------------------------------------------
>
> Key: AMBARI-12671
> URL: https://issues.apache.org/jira/browse/AMBARI-12671
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Affects Versions: 2.1.1
> Reporter: Rohit Choudhary
> Priority: Critical
> Fix For: 2.1.1
>
>
> PROBLEM: Progress bar in Hive view shows 100% but job is still running
> IMPACT: confusion to customers and don't know if it ran or not hence critical since it affects user experience.
> -download this file on your machine https://s3.amazonaws.com/hw-sandbox/tutorial1/NYSE-2000-2001.tsv.gz
> -now go to ambari hive views and execute to create the table:
> CREATE TABLE `nyse_stocks`(
> `exchange` string,
> `stock_symbol` string,
> `date` string,
> `stock_price_open` float,
> `stock_price_high` float,
> `stock_price_low` float,
> `stock_price_close` float,
> `stock_volume` bigint,
> `stock_price_adj_close` float)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\t'
> STORED AS INPUTFORMAT
> 'org.apache.hadoop.mapred.TextInputFormat'
> OUTPUTFORMAT
> 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
> -now upload file as mentioned above, using the files browser view and place it in the newly created path:
> /apps/hive/warehouse/nyse_stocks/
> -go to hive view and execute select count(*) from nyse_stocks;
> it should error
> then execute it again after you should see the attached screenshot.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)