asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Jacobs <sjaco...@ucr.edu>
Subject Re: CASE capabilities in SQL++
Date Mon, 15 May 2017 21:25:30 GMT
Got it, thanks.
Steven

On Mon, May 15, 2017 at 2:23 PM, Yingyi Bu <buyingyi@gmail.com> wrote:

> b is not a collection -- it binds to the values in side the collection by
> the subquery (select value
> count(DataverseName) from Metadata.`Dataset`), one at a time.
>
> On Mon, May 15, 2017 at 2:20 PM, Steven Jacobs <sjaco002@ucr.edu> wrote:
>
> > 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 <buyingyi@gmail.com> 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 <
> > > vignesh.raghunathan90@gmail.com> 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 <sjaco002@ucr.edu>
> 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
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message