dfMjetyg

1create external table if not exists pixie.pranavjindal_board_to_language (
2  board_index bigint,
3  language STRING,
4  numPins bigint,
5  avg_lang_ratio FLOAT
6)
7row format delimited fields terminated by ',' lines terminated by '\n'
8 location 's3n://pinlogs/pixie/pranavjindal_board_to_language/';
9
10WITH board_basics as (
11  select * from pixie.pranavjindal_board_basics
12)
13
14
15insert overwrite table pixie.pranavjindal_board_to_language
16
17
18SELECT 
19  pixie_board_index.board_index,
20  lang_name,
21  sum(numPins),
22  avg(lang_ratio) AS laang_ratio_1
23  from board_basics join 
24  ( 
25    select * from pixie.board_index where dt='2016-10-11'
26  ) pixie_board_index
27  on board_basics.board_index = pixie_board_index.board_id
28GROUP
29  BY pixie_board_index.board_index, lang_name;