FAQ
Dear bc,
I write a query in my hive database for searching words from one table in another table. I write "SELECT cbd.* FROM cbd WHERE fname NOT IN ( SELECT fname FROM cbd_new )" hive query. But it returns error "FAILED: Parse Error: line 1:43 cannot recognize input near 'SELECT' 'fname' 'FROM' in expression specification". Please help us to resolve the problem.

nice
Arindam Mitra
Bridgetree Consultancy Pvt Ltd.
Kolkata-700156, India.
Mobile No:-8296042823
Email: amitra@bridgetree.com
Contact us: www.bridgetree.com

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupscm-users @
categorieshadoop
postedOct 18, '12 at 7:34a
activeOct 18, '12 at 7:34a
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Arindam Mitra: 1 post

People

Translate

site design / logo © 2022 Grokbase