When using the LIMIT clause you can get any 2 records coming back, do you have any records with anonymous for user?
You have to order the records to get a reliable output with the limit clause. —Andries > On Sep 9, 2015, at 7:11 AM, Assaf Lowenstein <[email protected]> wrote: > > Hello Drillers! > > I'm trying to run a query- > SELECT `user` from dfs.`<some local location>` LIMIT 2; //(user is a > reserved word according to your docs so back ticks are required). > > I'm getting a user column with 2 rows but both users are *anonymous *and > not the actual user name that appear in my JSON. > when I'm doing > SELECT > * > from dfs.`<some local location>` LIMIT 2; > then the user names appear right under the user column. > > Please advise. > Thanks! > > > -- > *Assaf Lowenstein*, *QA Manager, Totango* > http://www.totango.com | Contact me @ cell: +(972) 052-4235550
