Re: Basic Subquery Failure

Hi, Thanks a lot. The problem has been already fixed. Take a look: https://issues.apache.org/jira/browse/IGNITE-7879 On 21.03.2018 3:12, besquared wrote: Sorry about that I put them as raw text but it looks like it didn't go through.. I'll just try without markup this time CREATE TABLE

Re: Basic Subquery Failure

Sorry about that I put them as raw text but it looks like it didn't go through.. I'll just try without markup this time CREATE TABLE people ( id LONG PRIMARY KEY, name VARCHAR ); SELECT people.name, COUNT(1) AS rowcount FROM people JOIN ( SELECT DISTINCT name FROM

Re: Basic Subquery Failure

Hi, I can see neither the query nor the stack trace. Most likely you attached them as images. Please paste as text or HTML text. -- Denis On Mon, Mar 19, 2018 at 4:56 PM, besquared wrote: > I'm running 2.4.0 locally on a single node and I'm trying to get a basic > SQL

Basic Subquery Failure

I'm running 2.4.0 locally on a single node and I'm trying to get a basic SQL subquery to work and I seem to be having problems. The following is the simplest thing I could find to reproduce to the error: The error is as follows: Any help for what I'm doing wrong here would be appreciated.