# Cannot group using alias columns

**URL:** <https://discuss.elastic.co/t/cannot-group-using-alias-columns/294241>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [January 13, 2022, 7:31am UTC](https://discuss.elastic.co/t/cannot-group-using-alias-columns/294241 "2022-01-13T07:31:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yanghao](https://avatars.discourse-cdn.com/v4/letter/y/71e660/32.png) [@yanghao](https://discuss.elastic.co/u/yanghao)\
**Post date:** [January 13, 2022, 7:31am UTC](https://discuss.elastic.co/t/cannot-group-using-alias-columns/294241/1 "2022-01-13T07:31:30Z")

</div>

This sql query could get result

```auto
POST /_sql?format=txt
{
  "query": "select dt,sum(pay_order_cnt_1d) from (select dt,pay_order_cnt_1d from sol_t_order_home)t1 group by dt"
}

```

but when executing this sql query

```auto
POST /_sql?format=txt
{
  "query": "select datetime, sum(pay_order_cnt_1d) from (select dt as datetime,pay_order_cnt_1d from sol_t_order_home)t1 group by datetime"
}

```

it went wrong with following errMsg

```auto
{
  "error" : {
    "root_cause" : [
      {
        "type" : "sql_illegal_argument_exception",
        "reason" : "Cannot GROUP BY t1.datetime{r}#2399"
      }
    ],
    "type" : "sql_illegal_argument_exception",
    "reason" : "Cannot GROUP BY t1.datetime{r}#2399"
  },
  "status" : 500
}

```

can anyone explain it plz!!!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 10, 2022, 7:32am UTC](https://discuss.elastic.co/t/cannot-group-using-alias-columns/294241/2 "2022-02-10T07:32:22Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.