| Line 154... |
Line 154... |
| 154 |
<partitioning>
|
154 |
<partitioning>
|
| 155 |
<method>none</method>
|
155 |
<method>none</method>
|
| 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, source,
|
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,
|
| - |
|
161 |
SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,'://',-1),'/',1),'www.',-1) as source_url,
|
| 160 |
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,
|
| 161 |
hour(source_start_time) as source_start_hour
|
163 |
hour(source_start_time) as source_start_hour
|
| 162 |
from user
|
164 |
from user
|
| 163 |
where is_anonymous = 0;</sql>
|
165 |
where is_anonymous = 0;</sql>
|
| 164 |
<limit>0</limit>
|
166 |
<limit>0</limit>
|
| Line 271... |
Line 273... |
| 271 |
<precision>-2</precision>
|
273 |
<precision>-2</precision>
|
| 272 |
</field> <field> <name>sex</name>
|
274 |
</field> <field> <name>sex</name>
|
| 273 |
<rename/>
|
275 |
<rename/>
|
| 274 |
<length>-2</length>
|
276 |
<length>-2</length>
|
| 275 |
<precision>-2</precision>
|
277 |
<precision>-2</precision>
|
| 276 |
</field> <field> <name>source</name>
|
278 |
</field> <field> <name>source_start_date_id</name>
|
| 277 |
<rename/>
|
279 |
<rename/>
|
| 278 |
<length>-2</length>
|
280 |
<length>-2</length>
|
| 279 |
<precision>-2</precision>
|
281 |
<precision>-2</precision>
|
| 280 |
</field> <field> <name>source_start_date_id</name>
|
282 |
</field> <field> <name>source_start_hour</name>
|
| 281 |
<rename/>
|
283 |
<rename/>
|
| 282 |
<length>-2</length>
|
284 |
<length>-2</length>
|
| 283 |
<precision>-2</precision>
|
285 |
<precision>-2</precision>
|
| 284 |
</field> <field> <name>source_start_hour</name>
|
286 |
</field> <field> <name>source_type</name>
|
| - |
|
287 |
<rename/>
|
| - |
|
288 |
<length>-2</length>
|
| - |
|
289 |
<precision>-2</precision>
|
| - |
|
290 |
</field> <field> <name>source_url</name>
|
| 285 |
<rename/>
|
291 |
<rename/>
|
| 286 |
<length>-2</length>
|
292 |
<length>-2</length>
|
| 287 |
<precision>-2</precision>
|
293 |
<precision>-2</precision>
|
| 288 |
</field> <select_unspecified>N</select_unspecified>
|
294 |
</field> <select_unspecified>N</select_unspecified>
|
| 289 |
</fields> <cluster_schema/>
|
295 |
</fields> <cluster_schema/>
|