Github user jackylk commented on a diff in the pull request:
https://github.com/apache/carbondata/pull/2029#discussion_r172160130
--- Diff: docs/faq.md ---
@@ -143,38 +143,38 @@ INSERT INTO TABLE carbon_table SELECT id, city FROM
source_table;
When the column type in carbon table is different from the column
specified in select statement. The insert operation will still success, but you
may get NULL in result, because NULL will be substitute value when conversion
type failed.
## Why aggregate query is not fetching data from aggregate table?
-Following are the aggregate queries that wonât fetch data from aggregate
table:
+Following are the aggregate queries that won't fetch data from aggregate
table:
- **Scenario 1** :
When SubQuery predicate is present in the query.
-Example
+Example:
```
-create table gdp21(cntry smallint, gdp double, y_year date) stored by
'carbondata'
-create datamap ag1 on table gdp21 using 'preaggregate' as select cntry,
sum(gdp) from gdp group by ctry;
-select ctry from pop1 where ctry in (select cntry from gdp21 group by
cntry)
+create table gdp21(cntry smallint, gdp double, y_year date) stored by
'carbondata';
--- End diff --
remove `;`
---
