Hi.
On Fri 2002-07-26 at 11:00:31 -0400, [EMAIL PROTECTED] wrote:
> >
> >Hi Benjamin, Arjen
> >
> >I did some testing again. I have 75,000,000 rows table, after using group
> >by I got 62,300,000 rows.
> >If I use *nix -u sort, I got 74800,00 rows.
> >
> >I compared the two results, I feel I tru
>
>Hi Benjamin, Arjen
>
>I did some testing again. I have 75,000,000 rows table, after using group
>by I got 62,300,000 rows.
>If I use *nix -u sort, I got 74800,00 rows.
>
>I compared the two results, I feel I trust my *nix result. Some lines just
>miss in "group by' result, look like no reaso
Hi Benjamin, Vivian,
On Wed, 2002-07-24 at 05:23, Benjamin Pflugmann wrote:
> On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> > I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
> > All char fields are mixed with upper case letters, numbers(0-9) and
> >
Hi.
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
> All char fields are mixed with upper case letters, numbers(0-9) and
> sign(like $).
> Because there is no low case char, I don't have to put -f optio
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
sign(like $).
Because there is no low case char, I don't have to put -f option for unix sort.
Thanks.
At 08:23 PM 7/23/2002 +0200, Benjamin Pflugmann
Hi.
On Thu 2002-07-11 at 09:53:05 -0400, [EMAIL PROTECTED] wrote:
> Bhavin,
>
> I am using distinct all 15 fields and order by all 15 fields, but there is
> different order on 15 fields for distinct and order by.
Are all fields of binary types? If not, DISTINCT equals "sort -uf", not
"sort -u"
inal Message -
>From: "Vivian Wang" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, July 10, 2002 11:00 AM
>Subject: Question about group by or distinct
>
>
> > Hi,
> >
> > I have a 76,500,000 rows table with 15 fields.
> >
en sorted it
via the Linux sort.
Regards,
Bhavin.
- Original Message -
From: "Vivian Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 11:00 AM
Subject: Question about group by or distinct
> Hi,
>
> I have a 76,500,000 rows tab
Hi,
I have a 76,500,000 rows table with 15 fields.
I try to sort this rows on all fields, so I am using select all fields1
group by all fields2 or distinct all fields1 with order by all fields2.
After sort, I get 62,000,000 rows.
Then I use Linux unique sort, I dump out 76,500,000 table and us
