From user-return-21191-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Aug 15 17:36:23 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 20AAA180626 for ; Wed, 15 Aug 2018 17:36:21 +0200 (CEST) Received: (qmail 84568 invoked by uid 500); 15 Aug 2018 15:36:21 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 84558 invoked by uid 99); 15 Aug 2018 15:36:21 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2018 15:36:21 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id A2583C1589 for ; Wed, 15 Aug 2018 15:36:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.974 X-Spam-Level: * X-Spam-Status: No, score=1.974 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FROM_EXCESS_BASE64=0.105, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 5QyOCsh2_khh for ; Wed, 15 Aug 2018 15:36:18 +0000 (UTC) Received: from mail-oi0-f54.google.com (mail-oi0-f54.google.com [209.85.218.54]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 3D8465F1A1 for ; Wed, 15 Aug 2018 15:36:18 +0000 (UTC) Received: by mail-oi0-f54.google.com with SMTP id 13-v6so2650412ois.1 for ; Wed, 15 Aug 2018 08:36:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=s/tY+Jb9BJhECkbw8huqx+aEoTkPC+i6zw01tqOUgts=; b=QeyQMOzKR3wxVE83j95mFWlPEbJrbDiaAuFAIoWn/jDnXoTQA2um1uQyz27ZtKIQwG bZmr8RZqhGCmUK4lYxirghVxhfm1hl3PBXuNFF4MCyaa/DBa1TudIdmzCiAmQ4KhuCH/ 9LPlPwU7wMV7Ps5Q9xll9Jz1zaIqVtFrKksYtS1NzFUjhyjqS96rK+65LWpoWG8xA7KC 0A24ChSA+QrEf0q9VfnTrECWLTnqXXSBNBbjejfyFMHVAsZEGnAqOLWL2lDxqz6nwOxU 95femfGXZulwPy8+FOuvRGXMp+Lm0dlhqRxULpNukzwItDEAZaA2gAshF2pa1RJEvNoH pDXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=s/tY+Jb9BJhECkbw8huqx+aEoTkPC+i6zw01tqOUgts=; b=fqHh1OZxnXdGVhx3mDQ8NroMe7uHNm5aDgPjR0vbOvIyUHb/6AanxJsFQQdF+1KK+S xZBBH1A6a7KFJGvbfxMuqBUi9CRsBX4wkUwpIh0vuRY32YKrFf4TmE5xxUZVxGt1Td93 NWLi2xaM5zNmLJqIv2av69xtnJoLnnIQmuJZjUH5RhtqNVYH6djUTspo1KR9aWtyE54R d3Ed0MjQ7PtT0F1KqV0eLhppgiZbld1tO7ZVOJ3ZTmWU05NYwWtekv4sqdlaqQWAQlRG DOkhSLFNjKZoXgkz3w6SkJldu17ePrm/3m0h5NDtyqtd3kCSp7vysg1qfgs190cBJoxw pO9g== X-Gm-Message-State: AOUpUlHqebFrW0xu0vSMSBOdwzCgg/Upj4Zh+2GK85qPRDKW5PVUPtX8 JG2rvLyyi4tkXvH0YfEXSBJdzCelxiqZutHGd8J7avGX X-Google-Smtp-Source: AA+uWPy7IKtPsMP3sffHu8fdd/MTeN2yfXv26anyI2j8rTKActyanJb9lQGQhwxEBFsZrG679xAoPkcJtLagmPbh7wU= X-Received: by 2002:aca:586:: with SMTP id 128-v6mr10279019oif.185.1534347370786; Wed, 15 Aug 2018 08:36:10 -0700 (PDT) MIME-Version: 1.0 References: <1534315736673-0.post@n6.nabble.com> In-Reply-To: From: =?UTF-8?B?0JLRj9GH0LXRgdC70LDQsiDQmtC+0L/RgtC40LvQuNC9?= Date: Wed, 15 Aug 2018 18:36:01 +0300 Message-ID: Subject: Re: distributed-ddl extended-parameters section showing 404 page not found To: user@ignite.apache.org Content-Type: multipart/alternative; boundary="000000000000ff76e605737b15db" --000000000000ff76e605737b15db Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello Huang, Both of them should work. In any way, I would suggest using 'AFFINITY-KEY' instead of 'AFFINITYKEY'. You can find the details here: https://issues.apache.org/jira/browse/IGNITE-6270 By the way, I will try to update the docs. Thanks, S. =D1=81=D1=80, 15 =D0=B0=D0=B2=D0=B3. 2018 =D0=B3. =D0=B2 14:19, Huang Meilo= ng : > thank you slava, > > > it says that to specify an affinity key name we can use AFFINITI_KEY in > the Parameters section, > > " > > - AFFINITY_KEY=3D - specifies an affinity ke= y > name which > is a column of the PRIMARY KEY constraint. > - > > " > > > but in the example section, it uses affinityKey > > > > - SQL > > Copy > > CREATE TABLE IF NOT EXISTS Person ( > id int, > city_id int, > name varchar, > age int, > company varchar, > PRIMARY KEY (id, city_id) > ) WITH "template=3Dpartitioned,backups=3D1,affinitykey=3Dcity_id, key_typ= e=3DPersonKe > > > > which one works=EF=BC=9F > ------------------------------ > *=E5=8F=91=E4=BB=B6=E4=BA=BA:* =D0=92=D1=8F=D1=87=D0=B5=D1=81=D0=BB=D0=B0= =D0=B2 =D0=9A=D0=BE=D0=BF=D1=82=D0=B8=D0=BB=D0=B8=D0=BD > *=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4:* 2018=E5=B9=B48=E6=9C=8815=E6=97= =A5 16:14:34 > *=E6=94=B6=E4=BB=B6=E4=BA=BA:* user@ignite.apache.org > *=E4=B8=BB=E9=A2=98:* Re: distributed-ddl extended-parameters section sho= wing 404 page > not found > > Hello, > > Yep, the link is broken, unfortunately. > It seems it should be the following > https://apacheignite-sql.readme.io/docs/create-table#section-parameters > > Thanks, > S. > > =D1=81=D1=80, 15 =D0=B0=D0=B2=D0=B3. 2018 =D0=B3. =D0=B2 10:17, Huang Mei= long : > > I found it here: https://apacheignite-sql.readme.io/docs/getting-started > Getting Started - Apache Ignite SQL Documentation > > apacheignite-sql.readme.io > Apache Ignite is a memory-centric distributed database, caching, and > processing platform for transactional, analytical, and streaming workload= s, > delivering in-memory speeds at petabyte scale > > > """ > > to set other cache configurations for the table, you should use the > template parameter and provide the name of the cache configuration > previously registered(via XML or code). See extended parameters > section > for more details. > > """ > ------------------------------ > *=E5=8F=91=E4=BB=B6=E4=BA=BA:* dkarachentsev > *=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4:* 2018=E5=B9=B48=E6=9C=8815=E6=97= =A5 14:48:56 > *=E6=94=B6=E4=BB=B6=E4=BA=BA:* user@ignite.apache.org > *=E4=B8=BB=E9=A2=98:* Re: distributed-ddl extended-parameters section sho= wing 404 page > not found > > Hi, > > Where did you find it? It might be a broken link. > > Thanks! > -Dmitry > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ > > --000000000000ff76e605737b15db Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello Huang,

Both of them should work. = In any way, I would suggest=C2=A0using 'AFFINITY-KEY' instead of &#= 39;AFFINITYKEY'.
You can find the details here:=C2=A0https://issues.apach= e.org/jira/browse/IGNITE-6270

By the way, I wi= ll try to update the docs.

Thanks,
S.


=D1= =81=D1=80, 15 =D0=B0=D0=B2=D0=B3. 2018 =D0=B3. =D0=B2 14:19, Huang Meilong = <imsrch@outlook.com>:

thank you slava,=C2=A0


it says that=C2=A0to= specify an affinity key name we can use AFFINITI_KEY=C2=A0in the=C2=A0Parameters section,=C2=A0

"

  • AFFINITY= _KEY=3D<affinity key column name>=C2=A0- specifies an=C2=A0affinity key=C2=A0name which is a column of the=C2=A0PRIMARY KEY=C2=A0constraint.
"


but in the example section, it us= es affinityKey


CREATE TABLE IF NOT EXISTS Person (
  id int,
  city_id int,
  name varchar,
  age int,=20
  company varchar,
  PRIMARY KEY (id, city_id)
) WITH "template=3Dpartitioned,backups=3D1,<=
span style=3D"color:rgb(255,0,0)">affinitykey=3Dcity_id, key_type=3D=
PersonKe


which one works=EF=BC=9F

=E5=8F=91= =E4=BB=B6=E4=BA=BA: =D0=92=D1=8F=D1=87=D0=B5=D1=81=D0=BB=D0=B0=D0=B2 = =D0=9A=D0=BE=D0=BF=D1=82=D0=B8=D0=BB=D0=B8=D0=BD <slava.koptilin@gmail.com> =E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2018=E5=B9=B48=E6=9C=8815=E6= =97=A5 16:14:34
=E6=94=B6=E4=BB=B6=E4=BA=BA: user@ignite.apache.org
=E4=B8=BB=E9=A2=98: Re: distributed-ddl extended-parameters section = showing 404 page not found
=C2=A0
Hello,

Yep, the link is broken, unfortunately.
It seems it should be the following=C2=A0ht= tps://apacheignite-sql.readme.io/docs/create-table#section-parameters

Thanks,
S.

=D1=81=D1=80, 15 =D0=B0=D0=B2=D0=B3. 2018 =D0=B3. =D0=B2 1= 0:17, Huang Meilong <imsrch@outlook.com>:

I found it here:=C2=A0https://apacheign= ite-sql.readme.io/docs/getting-started

Getting Sta= rted - Apache Ignite SQL Documentation
apacheignit= e-sql.readme.io

"""

to set other cache configurations for the table, you should= use the=C2=A0template=C2=A0parameter and provide the name of the cache configuration previously registered(via = XML or code). See=C2=A0extended parameters=C2=A0secti= on for more details.

"""

=E5=8F=91=E4=BB=B6=E4=BA=BA: dkarachentsev <dkarachentsev@grid= gain.com>
=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4: 2018=E5=B9=B48=E6=9C=8815=E6= =97=A5 14:48:56
=E6=94=B6=E4=BB=B6=E4=BA=BA: user@ignite.apache.org
=E4=B8=BB=E9=A2=98: Re: distributed-ddl extended-parameters section = showing 404 page not found
=C2=A0
<= font size=3D"2">
Hi,<= br>
Where did you find it? It might be a broken link.

Thanks!
-Dmitry



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
--000000000000ff76e605737b15db--