That recommendation worked. For informational purposes, the following also worked:
select case when b > 50 THEN "true" ELSE "false" END from(select value count(DataverseName) from Metadata.`Dataset`) b ; It sounds like this shouldn't have worked though since b is a collection? Steven On Mon, May 15, 2017 at 2:16 PM, Yingyi Bu <[email protected]> wrote: > Any subquery returns a collection, so try the following: > > select case when (select value count (country) from Tweets1)[0] > 50 THEN > "true" ELSE "false" END; > > On Mon, May 15, 2017 at 2:16 PM, Vignesh Raghunathan < > [email protected]> wrote: > > > Hi Steven, > > > > Could you try indexing the result of the second 'select value count...' > > statement? > > > > > use experiments > > > select count (country) from Tweets1; > > > select case when (select value count (country) from Tweets1)[0] > 50 > > THEN > > > "true" ELSE "false" END; > > > > > > > > Thanks, > > Vignesh > > > > > On May 15, 2017, at 5:09 PM, Steven Jacobs <[email protected]> wrote: > > > > > > Hi all, > > > I'm trying to understand the capabilities of the "case" that we have in > > > SQL++. I tried the following queries and the two results don't seem to > > make > > > sense. Am I missing something? > > > > > > SQL++: > > > use experiments > > > select count (country) from Tweets1; > > > select case when (select value count (country) from Tweets1) > 50 THEN > > > "true" ELSE "false" END; > > > > > > RESULTS: > > > > > > { "$1": 36297735 } > > > > > > { "$1": "false" } > > > > > > Thanks, > > > Steven > > >
