Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Simple question FROM clause


Copy link to this message
-
RE: Simple question FROM clause
Ashish Thusoo 2010-08-30, 23:23
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:[EMAIL PROTECTED]]
Sent: Monday, August 30, 2010 3:16 PM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]