Subversion Repositories SmartDukaan

Rev

Rev 2856 | Rev 3280 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2856 Rev 2857
Line 155... Line 155...
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 id, email, name, is_anonymous, date_of_birth, sex, source,
 159 
    <sql>select id, email, name, is_anonymous, date_of_birth, sex, source,
160 
case when datediff(source_start_time, &apos;20101231&apos;) &gt; 0 then datediff(source_start_time, &apos;20101231&apos;) else 0 end as source_start_date_id,
160 
case when datediff(source_start_time, &apos;20101231&apos;) &gt; 0 then datediff(source_start_time, &apos;20101231&apos;) else 1 end as source_start_date_id,
161 
hour(source_start_time) as source_start_hour
 161 
hour(source_start_time) as source_start_hour
162 
from user
162 
from user
163 
where is_anonymous = 0;</sql>
 163 
where is_anonymous = 0;</sql>
164 
    <limit>0</limit>
 164 
    <limit>0</limit>
165 
    <lookup/>
 165 
    <lookup/>