i trying retrieve long set of result , in doing find result data being truncated automatically. noticed limit of result(string) 1024 characters. how can avoid whole data?
i accessing tables through jdbc, if matters.
code:-
select oll.email_id,count(1) total_orders,oll.shipping_name ,sum(off.unit_price*off.quantity) total_gmv, min(odd.creation_date) first_purchase,max(odd.creation_date) last_purchase,group_concat(off.payment_mode) pay_modes, group_concat(ofll.product_id)as product_ids,left(group_concat(ofll.product_name),2048) products,oll.brand_name,group_concat(off.gctype) gctype, oll.shipping_city,oll.shipping_state,group_concat(off.unit_price-off.unit_shipping_price) product_price,group_concat(ceiling(off.quantity*off.unit_price)) product_gmv,group_concat(ofll.channel) sales_channel ( select count(1), ol.order_id, ol.email_id, ofl.created_by,ol.seller_city,ol.shipping_state (select creation_date,order_id,order_item_seq_id order_dates creation_date between '2015-01-30 23:55:00' , '2015-01-30 23:59:59') od inner join order_logistics ol on od.order_id = ol.order_id , od.order_item_seq_id = ol.order_item_seq_id inner join order_finance of on ol.order_id = of.order_id , ol.order_item_seq_id = of.order_item_seq_id inner join order_filters ofl on ol.order_id = ofl.order_id , ol.order_item_seq_id = ofl.order_item_seq_id inner join order_status os on ol.order_id = os.order_id , ol.order_item_seq_id = os.order_item_seq_id (of.payment_mode='cash on delivery' or os.payment_status='received')and (ofl.product_id in ('b4333897','b5163012','b5654542') or of.unit_price-of.unit_shipping_price='1.00') , ofl.channel in ('web channel', 'mobile web channel') , ol.email_id not null group ol.email_id) aaa, order_logistics oll, order_filters ofll, order_finance off,order_dates odd aaa.email_id=oll.email_id , oll.order_id=ofll.order_id , oll.order_item_seq_id=ofll.order_item_seq_id , (ofll.product_id in ('b4333897','b5163012','b5654542') or off.unit_price-off.unit_shipping_price='1.00') , ofll.order_id=odd.order_id , off.order_id=oll.order_id , off.order_item_seq_id=oll.order_item_seq_id group oll.email_id since using group_concat(), result comes out lengthy , that's gets truncated.
Comments
Post a Comment