Hive Assignment 1, Question 6 Solution Issue, ParseException expecting identifier near EOF


2 Answer(s)


I solved the problem by removing as before np join and nd on but perhaps someone can explain why it is like this? The following is the successful query I ran:

select np.stock_symbol, highest_price, highest_dividends from (select stock_symbol, max(stock_price_close) as highest_price from nasdaq_prices group by stock_symbol) np join (select stock_symbol, max(dividends) as highest_dividends from nasdaq_dividend group by stock_symbol) nd on np.stock_symbol = nd.stock_symbol;



hi Robert,

Thank you for raising the issue, this seems like a bug in the query that was provided. Again the Question7 also has the same issue. We will correct these.

Thanks