| Line 179... |
Line 179... |
| 179 |
<method>none</method>
|
179 |
<method>none</method>
|
| 180 |
<schema_name/>
|
180 |
<schema_name/>
|
| 181 |
</partitioning>
|
181 |
</partitioning>
|
| 182 |
<connection>transactionDC_Prod</connection>
|
182 |
<connection>transactionDC_Prod</connection>
|
| 183 |
<sql>SELECT SQL_NO_CACHE o.id 'order_id', o.customer_id, o.customer_pincode,
|
183 |
<sql>SELECT SQL_NO_CACHE o.id 'order_id', o.customer_id, o.customer_pincode,
|
| 184 |
o.status 'order_status', o.total_amount,
|
184 |
o.status 'order_status', o.total_amount, o.pickupStoreId,
|
| 185 |
datediff(o.created_timestamp, '20101231') as date_id, hour(o.created_timestamp) as order_hour,
|
185 |
datediff(o.created_timestamp, '20101231') as date_id, hour(o.created_timestamp) as order_hour,
|
| 186 |
o.transaction_id, l.item_id, l.quantity,
|
186 |
o.transaction_id, l.item_id, l.quantity,
|
| 187 |
case when unit_price<250 then 0 when unit_price<500 then 1 when unit_price<1000 then 2 when unit_price<2000 then 3 when unit_price < 5000 then 4 when unit_price < 10000 then 5 when unit_price < 15000 then 6 when unit_price <20000 then 7 when unit_price < 50000 then 8 else 9 end as price_range,
|
187 |
case when unit_price<250 then 0 when unit_price<500 then 1 when unit_price<1000 then 2 when unit_price<2000 then 3 when unit_price < 5000 then 4 when unit_price < 10000 then 5 when unit_price < 15000 then 6 when unit_price <20000 then 7 when unit_price < 50000 then 8 else 9 end as price_range,
|
| 188 |
l.transfer_price, p.gatewayId,
|
188 |
l.transfer_price, p.gatewayId,
|
| 189 |
case when pa.value is null then case when p.gatewayId = 1 then 2099 when p.gatewayId = 2 then 1099 else null end else pa.value end 'payment_method',
|
189 |
case when pa.value is null then case when p.gatewayId = 1 then 2099 when p.gatewayId = 2 then 1099 else null end else pa.value end 'payment_method',
|
| Line 245... |
Line 245... |
| 245 |
<precision>-2</precision>
|
245 |
<precision>-2</precision>
|
| 246 |
</field> <field> <name>total_amount</name>
|
246 |
</field> <field> <name>total_amount</name>
|
| 247 |
<rename/>
|
247 |
<rename/>
|
| 248 |
<length>-2</length>
|
248 |
<length>-2</length>
|
| 249 |
<precision>-2</precision>
|
249 |
<precision>-2</precision>
|
| - |
|
250 |
</field> <field> <name>pickupStoreId</name>
|
| - |
|
251 |
<rename/>
|
| - |
|
252 |
<length>-2</length>
|
| - |
|
253 |
<precision>-2</precision>
|
| 250 |
</field> <field> <name>date_id</name>
|
254 |
</field> <field> <name>date_id</name>
|
| 251 |
<rename/>
|
255 |
<rename/>
|
| 252 |
<length>-2</length>
|
256 |
<length>-2</length>
|
| 253 |
<precision>-2</precision>
|
257 |
<precision>-2</precision>
|
| 254 |
</field> <field> <name>order_hour</name>
|
258 |
</field> <field> <name>order_hour</name>
|
| Line 422... |
Line 426... |
| 422 |
</field>
|
426 |
</field>
|
| 423 |
<field>
|
427 |
<field>
|
| 424 |
<column_name>booking_date_id</column_name>
|
428 |
<column_name>booking_date_id</column_name>
|
| 425 |
<stream_name>booking_date_id</stream_name>
|
429 |
<stream_name>booking_date_id</stream_name>
|
| 426 |
</field>
|
430 |
</field>
|
| - |
|
431 |
<field>
|
| - |
|
432 |
<column_name>pickupStoreId</column_name>
|
| - |
|
433 |
<stream_name>pickupStoreId</stream_name>
|
| - |
|
434 |
</field>
|
| 427 |
</fields>
|
435 |
</fields>
|
| 428 |
<cluster_schema/>
|
436 |
<cluster_schema/>
|
| 429 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
437 |
<remotesteps> <input> </input> <output> </output> </remotesteps> <GUI>
|
| 430 |
<xloc>630</xloc>
|
438 |
<xloc>630</xloc>
|
| 431 |
<yloc>161</yloc>
|
439 |
<yloc>161</yloc>
|