Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of mauro.fagnoni@gmail.com
 designates 209.85.215.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=W/YTEVRnZQ2XNkyot+wMSSTdtQQq5TVDsTAZUCtuwA20Qjp0xPfb2rfT7SdQDRGcZH
         H+Dz6femuY/mUgkCzWx9owFkgpbOUzFeZ7EtiONNq6PsqZU+3ej2a5AG7i7dFv3x7FQO
         YKEgh/jWypQ/YgUNvSeRc/ImRycN0Ja/F8oSk=
MIME-Version: 1.0
From: Mauro Fagnoni <mauro.fagnoni@gmail.com>
Date: Mon, 16 May 2011 16:52:22 +0200
Message-ID: <BANLkTimvXY0BUoZQ74Z8JPUZGMs4RwPCGw@mail.gmail.com>
Subject: convert data query into map/reduce function
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=0015174bdd0ebae35b04a365ce1b

--0015174bdd0ebae35b04a365ce1b
Content-Type: text/plain; charset=ISO-8859-1

Hi all, i've to convert this sql query into couchdb  function but i've some
problem with reduce function. Some one can help me??
Many thanks and best regards

*
SQL QUERY:*

SELECT
             L_RETURNFLAG,
             L_LINESTATUS,
     sum(L_QUANTITY)as sum_qty,
     sum(L_EXTENDEDPRICE) as sum_base_price,
     sum(L_EXTENDEDPRICE*(1-L_DISCOUNT)) as sum_disc_price,
     sum(L_EXTENDEDPRICE*(1-L_DISCOUNT)*(1+L_TAX)) as sum_charge,
     avg(L_QUANTITY) as avg_qty, avg(L_EXTENDEDPRICE) as avg_price,
     avg(L_DISCOUNT) as avg_disc,count(*) as count_order
FROM
             LINEITEM
WHERE
             L_SHIPDATE <= date '1998-12-01' - interval '90' day"

GROUP BY
            L_RETURNFLAG,
            L_LINESTATUS
ORDER BY
            L_RETURNFLAG,
            L_LINESTATUS


couchdb function by curl

curl -X POST http://127.0.0.1:5984/testdb/_temp_view -H "Content-Type:
application/json" -d'{"map":"function("doc"){if(doc.l_shipdate <=
1998-09-01) emit(doc)}" "reduce":"function{if(.....)}}


-- 
-----------------------------------------------
[-------WHOAMI------] Mauro Fagnoni
[----------ICQ#---------] 279572903
[--------MSNID--------] maurofagnoni@yahoo.it
[--YAHOOMSNID--] maurofagnoni@gmail.com
[--GOOGLETALK--] mauro.fagnoni@gmail.com
[-GOOGLEWAVE-] mauro.fagnoni@googlewave.com
[------JABBER-------] mauro.fagnoni@gmail.com
[------SKYPE--------] mauro.fagnoni
[-----LinuxUser#----] 346345
[----------Blog---------] http://kingmauro.wordpress.com
-----------------------------------------------

--0015174bdd0ebae35b04a365ce1b--