[jira] [Created] (CARBONDATA-2349) Unresolved operator exception when avg is used on streaming aggregate table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-2349) Unresolved operator exception when avg is used on streaming aggregate table

Akash R Nilugal (Jira)
Kunal Kapoor created CARBONDATA-2349:
----------------------------------------

             Summary: Unresolved operator exception when avg is used on streaming aggregate table
                 Key: CARBONDATA-2349
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2349
             Project: CarbonData
          Issue Type: Bug
            Reporter: Kunal Kapoor
            Assignee: kumar vishal


CREATE TABLE IF NOT EXISTS tradeflow_st2(
 m_month      smallint,
 hs_code      string  ,
 country      smallint,
 dollar_value double  ,      
 quantity     double  ,
 unit         smallint,
 b_country    smallint,
 imex         smallint,
 y_year       smallint) 
STORED BY 'org.apache.carbondata.format'  TBLPROPERTIES('streaming'='true','SORT_SCOPE'='GLOBAL_SORT','table_blocksize'='256','sort_columns'='y_year,imex,country,b_country,hs_code,m_month,unit');

create datamap agg2 ON TABLE tradeflow_st2 USING "preaggregate" as  select avg(unit),imex,b_country,m_month from tradeflow_st2 group by imex,b_country,m_month ;

select avg(unit),m_month from tradeflow_st2 group by m_month



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)