| Line 156... |
Line 156... |
| 156 |
<schema_name/>
|
156 |
<schema_name/>
|
| 157 |
</partitioning>
|
157 |
</partitioning>
|
| 158 |
<connection>userDC_Prod</connection>
|
158 |
<connection>userDC_Prod</connection>
|
| 159 |
<sql>select SQL_NO_CACHE id, email, name, is_anonymous, date_of_birth, sex,
|
159 |
<sql>select SQL_NO_CACHE id, email, name, is_anonymous, date_of_birth, sex,
|
| 160 |
case when source is null then 'Unknown' when source like 'DIRECT%' then 'Direct' when source like 'ORGANIC%' then 'Organic' when source like 'PAID%' then 'Paid' else 'Referer' end as source_type,
|
160 |
case when source is null then 'Unknown' when source like 'DIRECT%' then 'Direct' when source like 'ORGANIC%' then 'Organic' when source like 'PAID%' then 'Paid' else 'Referer' end as source_type,
|
| 161 |
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,'://',-1),'/',1),'www.',-1) as source_url,
|
161 |
SUBSTRING_INDEX(REPLACE(REPLACE(SUBSTR(source, LOCATE('http://', LCASE(source)), LENGTH(source)), 'http://', ''), 'www.', ''), '/', 1) as source_url,
|
| 162 |
case when datediff(source_start_time, '20101231') > 0 then datediff(source_start_time, '20101231') else 1 end as source_start_date_id,
|
162 |
case when datediff(source_start_time, '20101231') > 0 then datediff(source_start_time, '20101231') else 1 end as source_start_date_id,
|
| 163 |
hour(source_start_time) as source_start_hour
|
163 |
hour(source_start_time) as source_start_hour
|
| 164 |
from user
|
164 |
from user
|
| 165 |
where is_anonymous = 0;</sql>
|
165 |
where is_anonymous = 0;</sql>
|
| 166 |
<limit>0</limit>
|
166 |
<limit>0</limit>
|