What does a simple "select * from stringmap limit 10" return ?
On Mon, Mar 12, 2012 at 12:51 PM, Keith Wiley <kwi...@keithwiley.com> wrote: > On Mar 9, 2012, at 16:46 , Steven Wong wrote: > >> The LOCATION clause has to specify the directory that contains (only) your >> data files. > > I've tried it both ways: > > CREATE EXTERNAL TABLE stringmap (ObjectTypeCode INT, AttributeName STRING, > AttributeValue INT, LangId INT, Value STRING, DisplayOrder INT) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > STORED AS TEXTFILE > LOCATION '/crm/records/all/hiveTest'; > > CREATE EXTERNAL TABLE stringmap (ObjectTypeCode INT, AttributeName STRING, > AttributeValue INT, LangId INT, Value STRING, DisplayOrder INT) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > STORED AS TEXTFILE > LOCATION '/crm/records/all/hiveTest/StringMap.csv'; > > In both cases, "show tables" lists stringmap and "describe stringmap" > describes the columns shown above, but a basic query doesn't return any > results. > > What else should I try here? > > ________________________________________________________________________________ > Keith Wiley kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > "I used to be with it, but then they changed what it was. Now, what I'm with > isn't it, and what's it seems weird and scary to me." > -- Abe (Grandpa) Simpson > ________________________________________________________________________________ >
