| Line 155... |
Line 155... |
| 155 |
<schema_name/>
|
155 |
<schema_name/>
|
| 156 |
</partitioning>
|
156 |
</partitioning>
|
| 157 |
<connection>transactionDC_Prod</connection>
|
157 |
<connection>transactionDC_Prod</connection>
|
| 158 |
<sql>SELECT o.id 'order_id', o.customer_id, o.customer_pincode,
|
158 |
<sql>SELECT o.id 'order_id', o.customer_id, o.customer_pincode,
|
| 159 |
o.status 'order_status', o.total_amount,
|
159 |
o.status 'order_status', o.total_amount,
|
| 160 |
datediff(o.created_timestamp, '20110101') as date_id, hour(o.created_timestamp) as order_hour,
|
160 |
datediff(o.created_timestamp, '20111231') as date_id, hour(o.created_timestamp) as order_hour,
|
| 161 |
o.transaction_id, l.item_id, l.quantity, l.unit_price, l.transfer_price, p.gatewayId,
|
161 |
o.transaction_id, l.item_id, l.quantity, l.unit_price, l.transfer_price, p.gatewayId,
|
| 162 |
pa.value 'payment_method', t.coupon_code
|
162 |
pa.value 'payment_method', t.coupon_code, t.session_source,
|
| - |
|
163 |
datediff(t.session_start_time, '20111231') as session_start_date_id,
|
| - |
|
164 |
hour(t.session_start_time) as session_start_hour
|
| 163 |
FROM `order` o
|
165 |
FROM `order` o
|
| 164 |
left join lineitem l on(o.id = l.order_id )
|
166 |
left join lineitem l on(o.id = l.order_id )
|
| 165 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
|
167 |
left join payment.payment p on (o.transaction_id = p.merchantTxnId)
|
| 166 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
168 |
left join payment.paymentattribute pa on (p.id = pa.payment_id and pa.name = 'payMethod')
|
| 167 |
left join transaction t on (o.transaction_id = t.id)
|
169 |
left join transaction t on (o.transaction_id = t.id)
|
| Line 247... |
Line 249... |
| 247 |
<precision>-2</precision>
|
249 |
<precision>-2</precision>
|
| 248 |
</field> <field> <name>coupon_code</name>
|
250 |
</field> <field> <name>coupon_code</name>
|
| 249 |
<rename/>
|
251 |
<rename/>
|
| 250 |
<length>-2</length>
|
252 |
<length>-2</length>
|
| 251 |
<precision>-2</precision>
|
253 |
<precision>-2</precision>
|
| - |
|
254 |
</field> <field> <name>session_source</name>
|
| - |
|
255 |
<rename/>
|
| - |
|
256 |
<length>-2</length>
|
| - |
|
257 |
<precision>-2</precision>
|
| - |
|
258 |
</field> <field> <name>session_start_date_id</name>
|
| - |
|
259 |
<rename/>
|
| - |
|
260 |
<length>-2</length>
|
| - |
|
261 |
<precision>-2</precision>
|
| - |
|
262 |
</field> <field> <name>session_start_hour</name>
|
| - |
|
263 |
<rename/>
|
| - |
|
264 |
<length>-2</length>
|
| - |
|
265 |
<precision>-2</precision>
|
| 252 |
</field> <select_unspecified>N</select_unspecified>
|
266 |
</field> <select_unspecified>N</select_unspecified>
|
| 253 |
</fields> <cluster_schema/>
|
267 |
</fields> <cluster_schema/>
|
| 254 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
268 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 255 |
<xloc>371</xloc>
|
269 |
<xloc>371</xloc>
|
| 256 |
<yloc>160</yloc>
|
270 |
<yloc>160</yloc>
|