You have to create a dummy table. I think there is a JIRA open to provide a usage similar to the one you mentioned below.
Ashish -----Original Message----- From: elein [mailto:el...@varlena.com] Sent: Monday, August 30, 2010 3:16 PM To: hive-user@hadoop.apache.org Cc: elein Subject: Simple question FROM clause I would like to select some constants and there is no from clause, but hive says it needs one. Do I have to create a dummy table for these or is there a better way? select 'this', 'and', 'that'; elein el...@varlena.com