Re: Put docker image in Trafodion website

[Gunnar Tapper]

I do. I'll take a look.

On Wed, Nov 30, 2016 at 10:09 AM, Dave Birdsall 
wrote:

> Copying dev list. This is one of the things Gunnar knows.
>
>
>
> *From:* Christophe Le Rouzo [mailto:c...@esgyn.com]
> *Sent:* Wednesday, November 30, 2016 9:07 AM
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Put docker image in Trafodion website
>
>
>
> Makes sense Eason, from what I recall it’s complicated to do modifications
> on the Apache Trafodion website...
>
> Who could do it?
>
>
>
> Thx
>
> -clr
>
>
>
>
>
> *From:* Zhang, Yi (Eason) [mailto:yi.zh...@esgyn.cn ]
> *Sent:* Wednesday, November 30, 2016 2:05 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Put docker image in Trafodion website
>
>
>
> Suggest to put the link somewhere on apache trafodion website, so user
> would know that there’s a docker image for Trafodion.
>
>
>
>
>
> Thanks,
>
> Eason
>
>
>
> *From:* Christophe Le Rouzo [mailto:c...@esgyn.com ]
> *Sent:* Thursday, November 24, 2016 14:22
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Put docker image in Trafodion website
>
>
>
> It’s on the Docker web site Seth: https://hub.docker.com/r/
> trafodion/quickstart/ , do you want to put it elsewhere as well?
>
>
>
> Best,
>
> -clr
>
>
>
>
>
> *From:* Jin, Jian (Seth) [mailto:jian@esgyn.cn ]
> *Sent:* Wednesday, November 23, 2016 7:55 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Put docker image in Trafodion website
>
>
>
> Hello there,
>
>
>
> Can we build and put Trafodion docker image somewhere in community
> website. It is the most easy way to try and get feeling about Trafodion’s
> advantages.
>
>
>
> Best regards,
>
>
>
> 金剑 (Seth)
>
>
>
>
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion Chinese Communities

[Gunnar Tapper]

Hi,

What Trafodion communities exist in China on WeChat, QQ, etc.? How active
are these communities?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Loading JSON Data Into Trafodion

[Gunnar Tapper]

What's the recommended method to load JSON data into Trafodion?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: trafci connection info in a file

[Gunnar Tapper]

Hi Arvind,

Alas, this doesn't work since the command argument itself gets quoted in
addition to the argument value.

Gunnar

On Sat, Aug 13, 2016 at 2:53 AM, Arvind  wrote:

> Hi Gunnar,
>
>
>
> Defining a function/alias seems to be a good way to do it, unless you want
> trafci to prompt you for the hostname:port/username/password.
>
>
>
> Could you try by including double quotes in your function definition ?
> That should help execute commands via -q or -sql or -s as described in :
>
>
>
> http://trafodion.incubator.apache.org/docs/command_
> interface/index.html#trafci_option_params
>
>
>
> function arvci() { trafci.sh -h host.com:23400 -u usr -p pwd “$@”; }
>
>
>
> Alias should also work in the same way (enclose in single quotes)
>
>
>
>alias  arvci=’trafci.sh -h host.com:23400 -u usr -p
> pwd “$@” ‘
>
>
>
> Do excuse if I misunderstood the problem with function/alias definition.
>
>
>
> I’m not currently aware of how to pass the connection information for
> trafci– jdbc applications can pass the information to the driver via
> properties file. I’ll look up or someone on this list will chime in, if it
> is possible, with that information.
>
>
>
> Regard
>
> Arvind
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Friday, August 12, 2016 11:52 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* trafci connection info in a file
>
>
>
> Hi,
>
>
>
> I'm running trafci from a Linux box outside a Trafodion cluster. I'd
> really like to be able to type: trafci -q "get schemas;" or something like
> that rather than having to put in all the connection info.
>
>
>
> The Command Interface Guide shows how to set an alias but that doesn't
> allow optional parameters. So, I went with a function: function trafci() {
> ./trafci -h host.com:23400 -u usr -p pwd $@; }, which works as long as
> the argument string isn't quoted; the shell strips off the quotes.
>
>
>
> Is there a .trafci or something that I can populate with the connection
> info?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

trafci connection info in a file

[Gunnar Tapper]

Hi,

I'm running trafci from a Linux box outside a Trafodion cluster. I'd really
like to be able to type: trafci -q "get schemas;" or something like that
rather than having to put in all the connection info.

The Command Interface Guide shows how to set an alias but that doesn't
allow optional parameters. So, I went with a function: function trafci() {
./trafci -h host.com:23400 -u usr -p pwd $@; }, which works as long as the
argument string isn't quoted; the shell strips off the quotes.

Is there a .trafci or something that I can populate with the connection
info?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Create a table with BLOB or CLOB columns

[Gunnar Tapper]

Thanks!

On Tue, Apr 26, 2016 at 11:00 PM, Sandhya Sundaresan <
sandhya.sundare...@esgyn.com> wrote:

> Most likely looks like Trafodion 2.1.
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 9:27 PM
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Create a table with BLOB or CLOB columns
>
>
>
> When is this planned? I'm asking since there are a couple of chapters in
> the upcoming JDBC T4 Guide that discuss LOB support.
>
>
>
> On Tue, Apr 26, 2016 at 10:13 PM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> Yes – exactly. I have made most of them actually and will hold on until
> it’s ready to get enabled by default.
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 9:12 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Create a table with BLOB or CLOB columns
>
>
>
> Thanks Sandhya. I assume that the how-to is part of the upcoming changes
> to the SQL Reference Manual for BLOB/CLOB support?
>
> Gunnar
>
>
>
> On Tue, Apr 26, 2016 at 10:04 PM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> Hi Gunnar,
>
>It isn’t turned on by default in the code yet needs more
> testing/usage.  You need to set a couple of CQDs to enable. If you create a
> table without setting the CQD you will get  large varchar column instead.
>
>
>
> Take a look at the document attached  in this JIRA for some details :
> https://issues.apache.org/jira/browse/TRAFODION-1473
>
>
>
> And for simple examples on how to turn on the CQD and create , insert,and
> extract take a look at core/sql/regress/executor/TEST130 for several
> examples.
>
>
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 8:58 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Create a table with BLOB or CLOB columns
>
>
>
> How do I create a table with BLOB or CLOB columns?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Create a table with BLOB or CLOB columns

[Gunnar Tapper]

When is this planned? I'm asking since there are a couple of chapters in
the upcoming JDBC T4 Guide that discuss LOB support.

On Tue, Apr 26, 2016 at 10:13 PM, Sandhya Sundaresan <
sandhya.sundare...@esgyn.com> wrote:

> Yes – exactly. I have made most of them actually and will hold on until
> it’s ready to get enabled by default.
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 9:12 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Create a table with BLOB or CLOB columns
>
>
>
> Thanks Sandhya. I assume that the how-to is part of the upcoming changes
> to the SQL Reference Manual for BLOB/CLOB support?
>
> Gunnar
>
>
>
> On Tue, Apr 26, 2016 at 10:04 PM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> Hi Gunnar,
>
>It isn’t turned on by default in the code yet needs more
> testing/usage.  You need to set a couple of CQDs to enable. If you create a
> table without setting the CQD you will get  large varchar column instead.
>
>
>
> Take a look at the document attached  in this JIRA for some details :
> https://issues.apache.org/jira/browse/TRAFODION-1473
>
>
>
> And for simple examples on how to turn on the CQD and create , insert,and
> extract take a look at core/sql/regress/executor/TEST130 for several
> examples.
>
>
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 8:58 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Create a table with BLOB or CLOB columns
>
>
>
> How do I create a table with BLOB or CLOB columns?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Create a table with BLOB or CLOB columns

[Gunnar Tapper]

Thanks Sandhya. I assume that the how-to is part of the upcoming changes to
the SQL Reference Manual for BLOB/CLOB support?

Gunnar

On Tue, Apr 26, 2016 at 10:04 PM, Sandhya Sundaresan <
sandhya.sundare...@esgyn.com> wrote:

> Hi Gunnar,
>
>It isn’t turned on by default in the code yet needs more
> testing/usage.  You need to set a couple of CQDs to enable. If you create a
> table without setting the CQD you will get  large varchar column instead.
>
>
>
> Take a look at the document attached  in this JIRA for some details :
> https://issues.apache.org/jira/browse/TRAFODION-1473
>
>
>
> And for simple examples on how to turn on the CQD and create , insert,and
> extract take a look at core/sql/regress/executor/TEST130 for several
> examples.
>
>
>
> Thanks
>
> Sandhya
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, April 26, 2016 8:58 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Create a table with BLOB or CLOB columns
>
>
>
> How do I create a table with BLOB or CLOB columns?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Create a table with BLOB or CLOB columns

[Gunnar Tapper]

How do I create a table with BLOB or CLOB columns?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

JDBC Type 4 Character Set Support

[Gunnar Tapper]

Hi,

I'm working on a JDBC Type 4 guide based on previous materials. What's the
support for character-set mapping? Do we support the following:


   - ISO88591:ISO88591_1
   - KANJI:SJIS
   - KSC5601:EUR_CR

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: Hive data type that Trafodion current supported?

[Gunnar Tapper]

Yes, I was just going to respond with that and add the user list since
users might be interested in this question.

http://trafodion.apache.org/docs/sql_reference/index.html#type_mapping_from_hive_to_trafodion_sql

Please open a Jira if this information is insufficient.

Thanks,

Gunnar

On Thu, Apr 21, 2016 at 10:27 PM, Carol Pearson 
wrote:

> Is this documented in user documentation somewhere?
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Thu, Apr 21, 2016 at 6:11 PM, Liu, Ming (Ming) 
> wrote:
>
> > Thanks Anoop, that is a very good place to check the list.
> >
> > Thanks,
> > Ming
> >
> > -邮件原件-
> > 发件人: Anoop Sharma [mailto:anoop.sha...@esgyn.com]
> > 发送时间: 2016年4月22日 9:06
> > 收件人: d...@trafodion.incubator.apache.org
> > 主题: RE: Hive data type that Trafodion current supported?
> >
> > look at method getSQColTypeForHive in optimizer/NATable.cpp
> >
> > anoop
> >
> > -Original Message-
> > From: Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> > Sent: Thursday, April 21, 2016 6:02 PM
> > To: d...@trafodion.incubator.apache.org
> > Subject: Hive data type that Trafodion current supported?
> >
> > Hi, all,
> >
> > Does anyone know a full list of 'supported Hive data type' by Trafodion
> at
> > present, or how can I check this myself? Any hint into the src code that
> I
> > can take a look will also help a lot. Thanks in advance.
> > I need to design some tests against HIVE_SCAN, and try to get a full
> > coverage of supported data types.
> >
> > Thanks,
> > Ming
> >
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Logos

[Gunnar Tapper]

Hi,

The logo carousel is active on the trafodion website. Remember, we need
your permission and logo .jpg to add your company to the carousel.

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Instruction about how to become Trafodion contributor

[Gunnar Tapper]

I'd recommend looking through the Contributor Guide. We put a lot of effort
into it so if there are holes, then we need to fix them.

Gunnar

On Thu, Apr 14, 2016 at 11:43 PM, Jin, Jian (Seth) 
wrote:

> Thanks all, I find it finally.
>
>
>
> Br,
>
>
>
> Seth
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* 2016年4月15日 12:24
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Instruction about how to become Trafodion contributor
>
>
>
> I indeed did. Replying via cellphone didn't work so well. :)
>
>
>
> On Thu, Apr 14, 2016 at 10:10 PM, Carol Pearson <
> carol.pearson...@gmail.com> wrote:
>
> I think Gunnar meant to say, "Refer" to the Get Started chapter."
>
>
>
> The videos will compliment our website and writings, not replace them.
> Some people like to read.  Some people like to watch.  We'll cover both
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Thu, Apr 14, 2016 at 12:24 AM, Gunnar Tapper 
> wrote:
>
> Regret to the Get Started chapter.
>
> On Apr 13, 2016 9:25 PM, "Jin, Jian (Seth)"  wrote:
>
> Yes, I look at the link, but cannot find **process** how to register and
> be come contributor.
>
> Br,
>
>
>
> Seth
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* 2016年4月13日 21:11
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Instruction about how to become Trafodion contributor
>
>
>
> The link is provided directly by clicking on "Contribute" on the website.
>
>
>
> On Wed, Apr 13, 2016 at 3:38 AM, Pierre Smits 
> wrote:
>
> Hi Jian,
>
> First of all: welcome!
>
>
>
>
> https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Contributor+Guide
> should provide a good starting point.
>
>
>
> Best regards,
>
>
> Pierre Smits
>
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
>
> OFBiz based solutions & services
>
>
> *OFBiz Extensions Marketplace*
>
> http://oem.ofbizci.net/oci-2/
>
>
>
> On Wed, Apr 13, 2016 at 9:50 AM, Jin, Jian (Seth) 
> wrote:
>
> Hello there,
>
>
>
> It is not easy to find instruction How to become Trafodion contributor in
> official website or WiKi page.
>
> Did I miss it or we need to add this at proper place?
>
>
>
> Best regards,
>
>
>
> 金剑 (Seth)
>
>
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Instruction about how to become Trafodion contributor

[Gunnar Tapper]

I indeed did. Replying via cellphone didn't work so well. :)

On Thu, Apr 14, 2016 at 10:10 PM, Carol Pearson 
wrote:

> I think Gunnar meant to say, "Refer" to the Get Started chapter."
>
> The videos will compliment our website and writings, not replace them.
> Some people like to read.  Some people like to watch.  We'll cover both
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> -------
>
> On Thu, Apr 14, 2016 at 12:24 AM, Gunnar Tapper 
> wrote:
>
>> Regret to the Get Started chapter.
>> On Apr 13, 2016 9:25 PM, "Jin, Jian (Seth)"  wrote:
>>
>>> Yes, I look at the link, but cannot find **process** how to register and
>>> be come contributor.
>>>
>>> Br,
>>>
>>>
>>>
>>> Seth
>>>
>>>
>>>
>>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>>> *Sent:* 2016年4月13日 21:11
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* Re: Instruction about how to become Trafodion contributor
>>>
>>>
>>>
>>> The link is provided directly by clicking on "Contribute" on the website.
>>>
>>>
>>>
>>> On Wed, Apr 13, 2016 at 3:38 AM, Pierre Smits 
>>> wrote:
>>>
>>> Hi Jian,
>>>
>>> First of all: welcome!
>>>
>>>
>>>
>>>
>>> https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Contributor+Guide
>>> should provide a good starting point.
>>>
>>>
>>>
>>> Best regards,
>>>
>>>
>>> Pierre Smits
>>>
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>>
>>> OFBiz based solutions & services
>>>
>>>
>>> *OFBiz Extensions Marketplace*
>>>
>>> http://oem.ofbizci.net/oci-2/
>>>
>>>
>>>
>>> On Wed, Apr 13, 2016 at 9:50 AM, Jin, Jian (Seth) 
>>> wrote:
>>>
>>> Hello there,
>>>
>>>
>>>
>>> It is not easy to find instruction How to become Trafodion contributor
>>> in official website or WiKi page.
>>>
>>> Did I miss it or we need to add this at proper place?
>>>
>>>
>>>
>>> Best regards,
>>>
>>>
>>>
>>> 金剑 (Seth)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Thanks,
>>>
>>>
>>>
>>> Gunnar
>>>
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

RE: Instruction about how to become Trafodion contributor

[Gunnar Tapper]

Regret to the Get Started chapter.
On Apr 13, 2016 9:25 PM, "Jin, Jian (Seth)"  wrote:

> Yes, I look at the link, but cannot find **process** how to register and
> be come contributor.
>
> Br,
>
>
>
> Seth
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* 2016年4月13日 21:11
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Instruction about how to become Trafodion contributor
>
>
>
> The link is provided directly by clicking on "Contribute" on the website.
>
>
>
> On Wed, Apr 13, 2016 at 3:38 AM, Pierre Smits 
> wrote:
>
> Hi Jian,
>
> First of all: welcome!
>
>
>
>
> https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Contributor+Guide
> should provide a good starting point.
>
>
>
> Best regards,
>
>
> Pierre Smits
>
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
>
> OFBiz based solutions & services
>
>
> *OFBiz Extensions Marketplace*
>
> http://oem.ofbizci.net/oci-2/
>
>
>
> On Wed, Apr 13, 2016 at 9:50 AM, Jin, Jian (Seth) 
> wrote:
>
> Hello there,
>
>
>
> It is not easy to find instruction How to become Trafodion contributor in
> official website or WiKi page.
>
> Did I miss it or we need to add this at proper place?
>
>
>
> Best regards,
>
>
>
> 金剑 (Seth)
>
>
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>

Re: Instruction about how to become Trafodion contributor

[Gunnar Tapper]

The link is provided directly by clicking on "Contribute" on the website.

On Wed, Apr 13, 2016 at 3:38 AM, Pierre Smits 
wrote:

> Hi Jian,
>
> First of all: welcome!
>
>
> https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Contributor+Guide
> should provide a good starting point.
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Wed, Apr 13, 2016 at 9:50 AM, Jin, Jian (Seth) 
> wrote:
>
>> Hello there,
>>
>>
>>
>> It is not easy to find instruction How to become Trafodion contributor in
>> official website or WiKi page.
>>
>> Did I miss it or we need to add this at proper place?
>>
>>
>>
>> Best regards,
>>
>>
>>
>> 金剑 (Seth)
>>
>>
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: How to specify default charset of column in DDL create table?

[Gunnar Tapper]

Does this CQD apply to the CREATE PROCEDURE statement too?

On Wed, Apr 6, 2016 at 9:42 AM, Anoop Sharma  wrote:

> cqd traf_default_col_charset ‘UTF8’;
>
>
>
>
>
>
>
> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
> *Sent:* Wednesday, April 6, 2016 8:36 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: How to specify default charset of column in DDL create
> table?
>
>
>
> I had thought that CQD DEFAULT_CHARSET ‘UTF8’ would achieve this.
>
>
>
> But I tried it this morning, and it doesn’t seem to work. I still get
> ISO88591 by default on CREATE TABLE.
>
>
>
> Maybe something is broken.
>
>
>
> Dave
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *Sent:* Wednesday, April 6, 2016 8:28 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* How to specify default charset of column in DDL create table?
>
>
>
> Hi, all,
>
>
>
> When create a table in Trafodion, by default, CHAR/VARCHAR columns will
> have ISO88591 as charset. Is there any way to change this default behavior,
> so by default, create table will have UTF8 as charset,without explicitly
> specify in DDL.
>
>
>
> Thanks,
>
> Ming
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Mystical SPJ error

[Gunnar Tapper]

Found it. I defined the library using .class instead of .jar. Oops.

On Mon, Apr 4, 2016 at 6:22 PM, Gunnar Tapper 
wrote:

> Hi,
>
> This error is driving me batty. :)
>
> The SPJ information:
>
> [centos@trafodion trafodion-spjs]$ pwd
> /home/centos/trafodion-spjs
> [centos@trafodion trafodion-spjs]$ javap Payroll.class
> Compiled from "Payroll.java"
> public class Payroll {
>   public Payroll();
>   public static void adjustSalary(java.math.BigDecimal, double,
> java.math.BigDecimal[]) throws java.sql.SQLException;
>   public static void employeeJob(int, java.lang.Integer[]) throws
> java.sql.SQLException;
>   public static void projectTeam(int, java.sql.ResultSet[]) throws
> java.sql.SQLException;
>   public static void topSalesReps(int, java.sql.ResultSet[]) throws
> java.sql.SQLException;
> }
>
> So, I add the class to Trafodion as a library.
>
> [centos@trafodion trafodion-spjs]$ trafci
>
> Welcome to Apache Trafodion Command Interface
> Copyright (c) 2015 Apache Software Foundation
>
> Host Name/IP Address: localhost:23400
> User Name: zz
>
> Connected to Trafodion
>
> SQL>create library trafodion.persnl.payroll file
> '/home/centos/trafodion-spjs/Payroll.class';
>
> --- SQL operation complete.
>
> SQL>get libraries in schema trafodion.persnl;
>
> PAYROLL
>
> --- SQL operation complete.
>
> Next, I try to create a procedure but Trafodion doesn't seem to see the
> Payroll class in the library file.
>
> SQL>CREATE PROCEDURE trafodion.persnl.adjustsalary( IN empnum NUMERIC(4)
>   , IN percent FLOAT
>   , OUT newsalary NUMERIC(8,2)
>   )
>EXTERNAL NAME 'Payroll.adjustSalary'
>LIBRARY trafodion.persnl.payroll
> +>+>+>+>+>   LANGUAGE JAVA
>PARAMETER STYLE JAVA
>MODIFIES SQL DATA
>;
> +>+>+>+>
> *** ERROR[11205] Java class 'Payroll' was not found in external path
> '/home/centos/trafodion-spjs/Payroll.class'. [2016-04-05 00:16:46]
> *** ERROR[1231] User-defined routine TRAFODION.PERSNL.ADJUSTSALARY could
> not be created. [2016-04-05 00:16:46]
>
> SQL>
>
> What am I missing?
>
> Thanks,
>
> Gunnar
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Mystical SPJ error

[Gunnar Tapper]

Hi,

This error is driving me batty. :)

The SPJ information:

[centos@trafodion trafodion-spjs]$ pwd
/home/centos/trafodion-spjs
[centos@trafodion trafodion-spjs]$ javap Payroll.class
Compiled from "Payroll.java"
public class Payroll {
  public Payroll();
  public static void adjustSalary(java.math.BigDecimal, double,
java.math.BigDecimal[]) throws java.sql.SQLException;
  public static void employeeJob(int, java.lang.Integer[]) throws
java.sql.SQLException;
  public static void projectTeam(int, java.sql.ResultSet[]) throws
java.sql.SQLException;
  public static void topSalesReps(int, java.sql.ResultSet[]) throws
java.sql.SQLException;
}

So, I add the class to Trafodion as a library.

[centos@trafodion trafodion-spjs]$ trafci

Welcome to Apache Trafodion Command Interface
Copyright (c) 2015 Apache Software Foundation

Host Name/IP Address: localhost:23400
User Name: zz

Connected to Trafodion

SQL>create library trafodion.persnl.payroll file
'/home/centos/trafodion-spjs/Payroll.class';

--- SQL operation complete.

SQL>get libraries in schema trafodion.persnl;

PAYROLL

--- SQL operation complete.

Next, I try to create a procedure but Trafodion doesn't seem to see the
Payroll class in the library file.

SQL>CREATE PROCEDURE trafodion.persnl.adjustsalary( IN empnum NUMERIC(4)
  , IN percent FLOAT
  , OUT newsalary NUMERIC(8,2)
  )
   EXTERNAL NAME 'Payroll.adjustSalary'
   LIBRARY trafodion.persnl.payroll
+>+>+>+>+>   LANGUAGE JAVA
   PARAMETER STYLE JAVA
   MODIFIES SQL DATA
   ;
+>+>+>+>
*** ERROR[11205] Java class 'Payroll' was not found in external path
'/home/centos/trafodion-spjs/Payroll.class'. [2016-04-05 00:16:46]
*** ERROR[1231] User-defined routine TRAFODION.PERSNL.ADJUSTSALARY could
not be created. [2016-04-05 00:16:46]

SQL>

What am I missing?

Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Logos for the Apache Trafodion Website?

[Gunnar Tapper]

Actually, http://trafodion.incubator.apache.org for now. :)

Typo, I'm sure.

Gunnar

On Mon, Apr 4, 2016 at 5:28 PM, Venkat Muthuswamy <
venkat.muthusw...@esgyn.com> wrote:

> Shouldn’t it be http://trafodion.apache.org
>
>
>
> *From:* Pierre Smits [mailto:pierre.sm...@gmail.com]
> *Sent:* Monday, April 04, 2016 4:27 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Logos for the Apache Trafodion Website?
>
>
>
> HI Carol,
>
>
>
> That site can't be reached.
>
>
>
> Best regards,
>
>
> Pierre Smits
>
>
> *ORRTIZ.COM *
>
> OFBiz based solutions & services
>
>
> *OFBiz Extensions Marketplace*
>
> http://oem.ofbizci.net/oci-2/
>
>
>
> On Tue, Apr 5, 2016 at 12:34 AM, Carol Pearson 
> wrote:
>
> Hi Trafodion Fans,
>
>
>
> I was looking at the apache.trafodion.org website today and noticed we
> have some of our contributors' and  users' logos there.  If you'd like to
> have your organization's logo included to show their commitment to Open
> Source and to Trafodion, reply to this email or send an email to the users
> list and we can work through the details to get it there.
>
>
>
> Thanks!
>
> -Carol P.
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: add a comment to a table

[Gunnar Tapper]

Can you do the columns too while you're at it? Being able to embed
documentation is already a good thing. For example, we could document the
repository this way.

Also, do you plan to extend showddl to show the comments? Or, some other
means?

Thanks,

Gunnar

On Fri, Apr 1, 2016 at 7:02 AM, Liu, Ming (Ming)  wrote:

> Very good plan QiFan.
>
> Allow me file a JIRA then.
>
>
>
> Compatibility will be important.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Qifan Chen [mailto:qifan.c...@esgyn.com]
> *发送时间:* 2016年4月1日 18:31
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: add a comment to a table
>
>
>
> The implementation probably will be involving the following:
>
>1. add a new type for column TEXT_TYPE in meta-table
>TRAFODION."_MD_".TEXT, say COMMENT_TYPE;
>2. allow COMMENT ON syntax in the parser;
>3. convert the content of COMMENT ON stmt into insertion/update of a
>row(s) in the TEXT meta-data table for the SQL object in question;
>4. write a UDF to show the comment easily for a SQL object, by hiding
>the join of the meta-data TEXT and OBJECTS table.
>
> The task may be a little bit involving :-).
>
>
>
> Thanks  --Qifan
>
>
>
> On Fri, Apr 1, 2016 at 1:30 AM, Liu, Ming (Ming) 
> wrote:
>
> Shall we file a JIRA to track this requirement?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com]
> *发送时间**:* 2016年4月1日 11:54
> *收件人**:* user@trafodion.incubator.apache.org
> *主题**:* Re: add a comment to a table
>
>
>
> Hi,
>
>
>
> I do not think Trafodion currently supports Oracle's COMMENT ON syntax
>
> *https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm
> *
>
>
>
> *It will be a relatively simple feature to add but we do not have it today
> as far as I know.*
>
>
>
> *Thank you*
>
> *Suresh*
>
>
>
>
>
> On Thu, Mar 31, 2016 at 9:56 PM, yongqiang.z...@microinsight.com.cn <
> yongqiang.z...@microinsight.com.cn> wrote:
>
> Hi , all,
>
>
>
>
>
> I want to add a comment to a table,like the use of oracle"
> comment on table tablename
> is annotate", How to use jdbc way to implement it?
>
>
>
>
>
>
>
>
> --
>
> yongqiang.z...@microinsight.com.cn
>
>
>
>
>
>
>
> --
>
> Regards, --Qifan
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Gunnar Tapper]

An API that wraps the new API with the old interface thereby ensuring that
clients don't have to change just because the underlying software changed.
On Mar 30, 2016 9:09 AM, "Stack"  wrote:

> On Wed, Mar 30, 2016 at 8:11 AM, Gunnar Tapper 
> wrote:
>
>> It's 1.x AFAIK.
>>
>> HBase doesn't provide compatibility APIs, eh? Something to consider in
>> the future maybe.
>>
>>
> What is a compatibility API?
> St.Ack
>
>
>
>> Gunnar
>>
>> On Tue, Mar 29, 2016 at 8:47 PM, Stack  wrote:
>>
>>> On Tue, Mar 29, 2016 at 2:17 PM, Carol Pearson <
>>> carol.pearson...@gmail.com> wrote:
>>>
>>>> Hi Trafodion Users,
>>>>
>>>> As Trafodion Release 2.0 comes together, it's a challenge to make
>>>> Trafodion work with both HBase 0.98 and HBase 1.1 in the same code base.
>>>>
>>>> From discussions among Trafodion developers over on the dev list, the
>>>> resolution is that the upcoming 2.0 release will work with HBase 1.1 and
>>>> forward ONLY.  That is, there is no current way to use HBase 0.98 in the
>>>> upcoming Trafodion 2.0 release, coming very soon.
>>>>
>>>>
>>>
>>> Sounds good. Could you get away with T* 2.0 works w/ HBase 1.x rather
>>> than 1.1?  The API is fixed in hbase 1.x. Coprocessors though could change
>>> across minor versions 1.1 => 1.2 which might mess you up.
>>>
>>> St.Ack
>>>
>>>
>>>
>>>> If you want to use Trafodion with HBase 0.98, that code path is based
>>>> on the Trafodion 1.3 release which is currently available. Trafodion
>>>> Release 1.3 does NOT work with HBase 1.1.
>>>>
>>>> -Carol P.
>>>> ---
>>>> Email:carol.pearson...@gmail.com
>>>> Twitter:  @CarolP222
>>>> ---
>>>>
>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>

Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Gunnar Tapper]

It's 1.x AFAIK.

HBase doesn't provide compatibility APIs, eh? Something to consider in the
future maybe.

Gunnar

On Tue, Mar 29, 2016 at 8:47 PM, Stack  wrote:

> On Tue, Mar 29, 2016 at 2:17 PM, Carol Pearson  > wrote:
>
>> Hi Trafodion Users,
>>
>> As Trafodion Release 2.0 comes together, it's a challenge to make
>> Trafodion work with both HBase 0.98 and HBase 1.1 in the same code base.
>>
>> From discussions among Trafodion developers over on the dev list, the
>> resolution is that the upcoming 2.0 release will work with HBase 1.1 and
>> forward ONLY.  That is, there is no current way to use HBase 0.98 in the
>> upcoming Trafodion 2.0 release, coming very soon.
>>
>>
>
> Sounds good. Could you get away with T* 2.0 works w/ HBase 1.x rather than
> 1.1?  The API is fixed in hbase 1.x. Coprocessors though could change
> across minor versions 1.1 => 1.2 which might mess you up.
>
> St.Ack
>
>
>
>> If you want to use Trafodion with HBase 0.98, that code path is based on
>> the Trafodion 1.3 release which is currently available. Trafodion Release
>> 1.3 does NOT work with HBase 1.1.
>>
>> -Carol P.
>> ---
>> Email:carol.pearson...@gmail.com
>> Twitter:  @CarolP222
>> ---
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion documentation library is growing

[Gunnar Tapper]

Check it out: http://trafodion.apache.org/documentation.html

The Client Install guide is now up-to-date. It's easier to find the how-to
documentation for UDFs, code examples, the Contributor Guide, etc.

In pipeline: SPJ Guide, ODBC APIs, and JDBC APIs.

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

DCS default port

[Gunnar Tapper]

Hi,

Our documentation seems to disagree on which port is the default DCS port.
23400 or 37800?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion Client Binaries Download

[Gunnar Tapper]

Hi,

I'm trying to download and install the Trafodion clients from
http://traf-builds.esgyn.com/downloads/trafodion/publish/release/1.3.0/apache-trafodion-clients-1.3.0-incubating-bin.tar.gz

The contents of this file confuses me since it doesn't match what I
expected; that is, the apache-trafodion-clients-1.3.0-incubating-bin.tar
file contains the following in the Clients directory:


   - JDBCT4.zip
   - odb64_linux.tar.gz
   - TRAF_ODBC_Linux_Driver_64.tar.gz
   - trafci.zip

Given the Client Installation Guide, I expected to see a
TFODBC64-.msi file

Is this a mistake or are we not shipping TFODBC64-.msi file? If
so, should the references to installation of Windows ODBC be removed?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: DCS default port

[Gunnar Tapper]

OK. I'll update the manuals accodingly.

On Thu, Mar 17, 2016 at 12:04 AM, Anuradha Hegde 
wrote:

> No.. It should be 23400.
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 10:42 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: DCS default port
>
>
>
> Is 37800 valid in 1.3.0?
>
>
>
> On Wed, Mar 16, 2016 at 9:36 PM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
> 23400 is the default port. (37800 is an old value).
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 8:35 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* DCS default port
>
>
>
> Hi,
>
>
>
> Our documentation seems to disagree on which port is the default DCS port.
> 23400 or 37800?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: DCS default port

[Gunnar Tapper]

Is 37800 valid in 1.3.0?

On Wed, Mar 16, 2016 at 9:36 PM, Venkat Muthuswamy <
venkat.muthusw...@esgyn.com> wrote:

> 23400 is the default port. (37800 is an old value).
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 8:35 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* DCS default port
>
>
>
> Hi,
>
>
>
> Our documentation seems to disagree on which port is the default DCS port.
> 23400 or 37800?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Client Binaries Download

[Gunnar Tapper]

Hi,

I'm adding [Binary is included in this release] to the manual.

I need a bit of guidance on this:

I noticed that the make package debug build creates a winodbc directory but
that does not contain an installer?

I also tried to build a release package but the resulting tar files don't
contain the installer either?

So, I guess I'm wondering how an interested party would build/install the
Windows ODBC driver? From what I understand of licensing, it's OK to do so
since you accept whatever licenses there are; different from binary
distribution.

Thanks,

Gunnar

On Wed, Mar 16, 2016 at 4:09 PM, Steve Varnau 
wrote:

> See: https://issues.apache.org/jira/browse/TRAFODION-1893
>
>
>
> There is license issue with binary distribution of win-odbc under Apache.
> Until that gets fixed, we are not bundling win-odbc binary.  Source release
> only.
>
>
>
> --Steve
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 3:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion Client Binaries Download
>
>
>
> Hi,
>
>
>
> I'm trying to download and install the Trafodion clients from
> http://traf-builds.esgyn.com/downloads/trafodion/publish/release/1.3.0/apache-trafodion-clients-1.3.0-incubating-bin.tar.gz
>
>
>
> The contents of this file confuses me since it doesn't match what I
> expected; that is, the apache-trafodion-clients-1.3.0-incubating-bin.tar
> file contains the following in the Clients directory:
>
>
>
>- JDBCT4.zip
>- odb64_linux.tar.gz
>- TRAF_ODBC_Linux_Driver_64.tar.gz
>- trafci.zip
>
> Given the Client Installation Guide, I expected to see a
> TFODBC64-.msi file
>
>
>
> Is this a mistake or are we not shipping TFODBC64-.msi file? If
> so, should the references to installation of Windows ODBC be removed?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Client Binaries Download

[Gunnar Tapper]

Are there any instructions for how to build it on Windows?

I don't think we need it in the release package if we're instructing users
on how to build it on Windows.

Gunnar

On Wed, Mar 16, 2016 at 5:00 PM, Steve Varnau 
wrote:

> It has to be built on Windows, and then put in the core/conn/clients
> directory to be picked up in the build packaging.
>
>
>
> --Steve
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 3:49 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Trafodion Client Binaries Download
>
>
>
> Hi,
>
>
>
> I'm adding [Binary is included in this release] to the manual.
>
>
>
> I need a bit of guidance on this:
>
>
>
> I noticed that the make package debug build creates a winodbc directory
> but that does not contain an installer?
>
>
>
> I also tried to build a release package but the resulting tar files don't
> contain the installer either?
>
>
>
> So, I guess I'm wondering how an interested party would build/install the
> Windows ODBC driver? From what I understand of licensing, it's OK to do so
> since you accept whatever licenses there are; different from binary
> distribution.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Wed, Mar 16, 2016 at 4:09 PM, Steve Varnau 
> wrote:
>
> See: https://issues.apache.org/jira/browse/TRAFODION-1893
>
>
>
> There is license issue with binary distribution of win-odbc under Apache.
> Until that gets fixed, we are not bundling win-odbc binary.  Source release
> only.
>
>
>
> --Steve
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, March 16, 2016 3:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion Client Binaries Download
>
>
>
> Hi,
>
>
>
> I'm trying to download and install the Trafodion clients from
> http://traf-builds.esgyn.com/downloads/trafodion/publish/release/1.3.0/apache-trafodion-clients-1.3.0-incubating-bin.tar.gz
>
>
>
> The contents of this file confuses me since it doesn't match what I
> expected; that is, the apache-trafodion-clients-1.3.0-incubating-bin.tar
> file contains the following in the Clients directory:
>
>
>
>- JDBCT4.zip
>- odb64_linux.tar.gz
>- TRAF_ODBC_Linux_Driver_64.tar.gz
>- trafci.zip
>
> Given the Client Installation Guide, I expected to see a
> TFODBC64-.msi file
>
>
>
> Is this a mistake or are we not shipping TFODBC64-.msi file? If
> so, should the references to installation of Windows ODBC be removed?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: Anyway to start Trafodion without sqstart

[Gunnar Tapper]

OK. Then, it'll not be covered in the upcoming admin guide.

On Tue, Mar 15, 2016 at 2:05 PM, Sean Broeder 
wrote:

> I think the concept of a warm start is a carryover from early SeaQuest
> days.  A warm start was proposed to maintain some monitor and TM states,
> but it never was fully implemented.
>
>
>
> Regards,
>
> Sean
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *Sent:* Tuesday, March 15, 2016 10:03 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* 答复: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The purpose I guess is to bypass time-consuming database recovery if it is
> a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
> restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
> start. But I think this is just the concept. May not support yet? We
> studied the two gomon scripts, seems identical except some minor difference.
>
>
>
> And Narendra is correct, I misunderstand the startup code. It is possible.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com
> ]
> *发送时间:* 2016年3月16日 0:36
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
> wrote:
>
> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dum

Re: 答复: 答复: Anyway to start Trafodion without sqstart

[Gunnar Tapper]

>From what I understand, this will not work. What you need to do is to do
what gomon.cold does; that is, interact with sqshell telling it what you
want done.

On Tue, Mar 15, 2016 at 11:31 AM, Amanda Moran 
wrote:

> Hi there All-
>
> So this is what is suggested to be able to start Trafodion on each node
> individually:
>
> Run sqgen on each node.
>
> Create a new script that would be ran on each node (probably just a
> wrapper) that calls gomon.cold.
>
> How will this work for processes that are one per cluster, like the
> monitor?
>
> Thanks!
>
> On Tue, Mar 15, 2016 at 10:02 AM, Liu, Ming (Ming) 
> wrote:
>
>> The purpose I guess is to bypass time-consuming database recovery if it
>> is a warm start. Say, if you have a clean shutdown of Trafodion, you can
>> warm restart it. If one use ‘ckillall’, or simply loss power, one needs a
>> cold start. But I think this is just the concept. May not support yet? We
>> studied the two gomon scripts, seems identical except some minor difference.
>>
>>
>>
>> And Narendra is correct, I misunderstand the startup code. It is possible.
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *发送时间:* 2016年3月16日 0:36
>> *收件人:* user@trafodion.incubator.apache.org
>> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <
>> narendra.go...@esgyn.com> wrote:
>>
>> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
>> Selva mentioned)) to startup without sqstart.
>>
>>
>>
>> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
>> some other checks (like checks for orphan processes), and cleans up IPC
>> constructs (semaphores, queues, shared memory) via sqipcrm.
>>
>>
>>
>> Thanks,
>>
>> -Narendra
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *Sent:* Tuesday, March 15, 2016 8:10 AM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> The use case is how Apache Ambari works: it assume node-by-node
>> management of services. This is how you achieve rolling upgrades, stopping
>> all services on a node, etc.
>>
>>
>>
>> I wonder if it's possible to first start the monitor (using the startup
>> command) and then start/stop other components per node. Kind of a hybrid
>> model.
>>
>>
>>
>> DCS/REST should already support this use case since it's based on the
>> HBase model where the scripts start daemons on each configured node.
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
>> wrote:
>>
>> From my understanding, it is invalid to start trafodion on node by node
>> mode. Monitor simulate a single image of operating system from a bunch of
>> nodes. One process can be configured to be a pair: active and standby. So
>> when start a trafodion process, it will start two processes on two nodes.
>> It is hard to start a single node.
>>
>> Is there any use case to do so?
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
>> *发送时间**:* 2016年3月15日 22:27
>> *收件人**:* user@trafodion.incubator.apache.org
>> *主**题**:* RE: Anyway to start Trafodion without sqstart
>>
>>
>>
>> Yes.  The sqgen command takes in the configuration file for the trafodion
>> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
>> These generated scripts are copied to all nodes in the cluster. These
>> scripts are nothing but the commands to sqshell. sqstart uses either
>> gomon.cold or gomon.warm to start the Trafodion instance.
>>
>>
>>
>> Selva
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *Sent:* Monday, March 14, 2016 10:03 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: Anyway to start Trafodion without sqstart
>>
>>
>>
>> DCS and REST follow the HBase model so that should be a simple matter of
>> invoking the *-daemon.sh scripts.
>>
>>
>>

Re: 答复: where to download Trafodion odbc/jdbc install package?

[Gunnar Tapper]

Hi,

Just to complicate this a bit... :)

The documentation for the Trafodion client software is:
http://trafodion.apache.org/docs/client_install/index.html

It might be necessary to add a column that describes the content of each
document if people can't correlate "client" with "ODBC" or "JDBC" on the
download page.

Thanks,

Gunnar


On Tue, Mar 15, 2016 at 10:25 AM, Dave Birdsall 
wrote:

> Done. https://issues.apache.org/jira/browse/TRAFODION-1894
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:52 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: where to download Trafodion odbc/jdbc install package?
>
>
>
> I suggest a Jira and then anyone can make the change. :)
>
>
>
> On Tue, Mar 15, 2016 at 9:45 AM, Carol Pearson 
> wrote:
>
> I think Dave and Ming are onto something. If I'm looking for ODBC or JDBC
> drivers, I'm most likely searching for "ODBC" or "JDBC" not "Clients". 6
>
>
>
>  If we could list these on the page somehow, that would be very helpful -
> not just for searching, but also once I land on that page, I know what it
> is I'm supposed to click to download the drivers.
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> -----------
>
>
>
> On Tue, Mar 15, 2016 at 8:21 AM, Dave Birdsall 
> wrote:
>
> Maybe it would be useful to list on the download page what’s in the
> Clients package?
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 7:08 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: where to download Trafodion odbc/jdbc install package?
>
>
>
> It's because the package contains more than JDBC and ODBC.
>
>
>
> On Mon, Mar 14, 2016 at 7:48 PM, Liu, Ming (Ming) 
> wrote:
>
> Sorry, my bad, it is in the
> http://trafodion.incubator.apache.org/download.html , it is called
> ‘Trafodion Clients’ I overlook it, I was looking for ODBC/JDBC .. .
>
>
>
> Ming
>
>
>
> *发件人**:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *发送时间**:* 2016年3月15日 9:45
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* where to download Trafodion odbc/jdbc install package?
>
>
>
> Hi, all,
>
>
>
> I am trying to download and install odbc/jdbc driver for Trafodion, but I
> spent over 15 mins on the http://trafodion.incubator.apache.org/ still
> not find the correct link.
>
> Could someone kindly help me?
>
>
>
> I suggest this should be put in a very easy to find link in the main page.
>
>
>
> Thanks,
>
> Ming
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: Anyway to start Trafodion without sqstart

[Gunnar Tapper]

BTW, in what cases should gomon.warm or the sqstart warm argument be used?

Thanks,

Gunnar

On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal 
wrote:

> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) 
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dump [{path }]  | 
>
> [SHELL] -- echo []
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri ][name ]
>
> [SHELL]   [nid ][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --[in |#default][out |#default]}] path
> [[]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}]  | 
>
> [SHELL] -- ldpath [[,]...]
>
> [SHELL] -- ls [{[detail]}] []
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info []]
>
> [SHELL] -- path [[,]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid ]|[process ]}] key=
>
> [SHELL] -- show [{[nid ]|[process ]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] []
>
> [SHELL] -- suspend []
>
> [SHELL] -- time 
>
> [SHELL] -- trace 
>
> [SHELL] -- up 
>
> [SHELL] -- wait [ | ]
>
> [SHELL] -- warmstart [trace] []
>
> [SHELL] -- zone [nid |zid ]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: where to download Trafodion odbc/jdbc install package?

[Gunnar Tapper]

I suggest a Jira and then anyone can make the change. :)

On Tue, Mar 15, 2016 at 9:45 AM, Carol Pearson 
wrote:

> I think Dave and Ming are onto something. If I'm looking for ODBC or JDBC
> drivers, I'm most likely searching for "ODBC" or "JDBC" not "Clients". 6
>
>  If we could list these on the page somehow, that would be very helpful -
> not just for searching, but also once I land on that page, I know what it
> is I'm supposed to click to download the drivers.
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Tue, Mar 15, 2016 at 8:21 AM, Dave Birdsall 
> wrote:
>
>> Maybe it would be useful to list on the download page what’s in the
>> Clients package?
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>> *Sent:* Monday, March 14, 2016 7:08 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: 答复: where to download Trafodion odbc/jdbc install package?
>>
>>
>>
>> It's because the package contains more than JDBC and ODBC.
>>
>>
>>
>> On Mon, Mar 14, 2016 at 7:48 PM, Liu, Ming (Ming) 
>> wrote:
>>
>> Sorry, my bad, it is in the
>> http://trafodion.incubator.apache.org/download.html , it is called
>> ‘Trafodion Clients’ I overlook it, I was looking for ODBC/JDBC .. .
>>
>>
>>
>> Ming
>>
>>
>>
>> *发件人**:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
>> *发送时间**:* 2016年3月15日 9:45
>> *收件人**:* user@trafodion.incubator.apache.org
>> *主**题**:* where to download Trafodion odbc/jdbc install package?
>>
>>
>>
>> Hi, all,
>>
>>
>>
>> I am trying to download and install odbc/jdbc driver for Trafodion, but I
>> spent over 15 mins on the http://trafodion.incubator.apache.org/ still
>> not find the correct link.
>>
>> Could someone kindly help me?
>>
>>
>>
>> I suggest this should be put in a very easy to find link in the main page.
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: Anyway to start Trafodion without sqstart

[Gunnar Tapper]

The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.

I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.

DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.

Gunnar

On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming)  wrote:

> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间:* 2016年3月15日 22:27
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] []} | {-c }
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd 
>
> [SHELL] -- delay 
>
> [SHELL] -- down  [, ]
>
> [SHELL] -- dump [{path }]  | 
>
> [SHELL] -- echo []
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri ][name ]
>
> [SHELL]   [nid ][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --[in |#default][out |#default]}] path
> [[]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}]  | 
>
> [SHELL] -- ldpath [[,]...]
>
> [SHELL] -- ls [{[detail]}] []
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info []]
>
> [SHELL] -- path [[,]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid ]|[process ]}] key=
>
> [SHELL] -- show [{[nid ]|[process ]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] []
>
> [SHELL] -- suspend []
>
> [SHELL] -- time 
>
> [SHELL] -- trace 
>
> [SHELL] -- up 
>
> [SHELL] -- wait [ | ]
>
> [SHELL] -- warmstart [trace] []
>
> [SHELL] -- zone [nid |zid ]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Anyway to start Trafodion without sqstart

[Gunnar Tapper]

DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] []} | {-c }
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${}
[SHELL] -- ! comment statement
[SHELL] -- cd 
[SHELL] -- delay 
[SHELL] -- down  [, ]
[SHELL] -- dump [{path }]  | 
[SHELL] -- echo []
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}]  [ [
event-data] ]
[SHELL] -- exec [{[debug][nowait][pri ][name ]
[SHELL]   [nid ][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --[in |#default][out |#default]}] path
[[]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}]  | 
[SHELL] -- ldpath [[,]...]
[SHELL] -- ls [{[detail]}] []
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info []]
[SHELL] -- path [[,]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [|]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid ]|[process ]}] key=
[SHELL] -- show [{[nid ]|[process ]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] []
[SHELL] -- suspend []
[SHELL] -- time 
[SHELL] -- trace 
[SHELL] -- up 
[SHELL] -- wait [ | ]
[SHELL] -- warmstart [trace] []
[SHELL] -- zone [nid |zid ]
[

Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran 
wrote:

> Hi there-
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
> Thanks!
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: where to download Trafodion odbc/jdbc install package?

[Gunnar Tapper]

It's because the package contains more than JDBC and ODBC.

On Mon, Mar 14, 2016 at 7:48 PM, Liu, Ming (Ming)  wrote:

> Sorry, my bad, it is in the
> http://trafodion.incubator.apache.org/download.html , it is called
> ‘Trafodion Clients’ I overlook it, I was looking for ODBC/JDBC .. .
>
>
>
> Ming
>
>
>
> *发件人:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *发送时间:* 2016年3月15日 9:45
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* where to download Trafodion odbc/jdbc install package?
>
>
>
> Hi, all,
>
>
>
> I am trying to download and install odbc/jdbc driver for Trafodion, but I
> spent over 15 mins on the http://trafodion.incubator.apache.org/ still
> not find the correct link.
>
> Could someone kindly help me?
>
>
>
> I suggest this should be put in a very easy to find link in the main page.
>
>
>
> Thanks,
>
> Ming
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Request for information about the installer's new management nodes prompt.

[Gunnar Tapper]

Hi,

Amanda can correct me if I'm wrong but I think that this refers to
configurations where the distribution manager (Ambari or Cloudera) runs on
separate nodes in the cluster. That is, the nodes are part of the cluster
but is not used as edge nodes or storage nodes and, therefore, should not
have Trafodion services installed on them.

Gunnar

On Tue, Mar 8, 2016 at 2:35 PM, D. Markt  wrote:

> Hi,
>
>   Some time back I noticed a new prompt as I was installing a Trafodion
> build:
>
> Do you have a set of management nodes (Y/N), default is N:
>
>   I was wondering how to appropriately answer this prompt to use the new
> feature as it was intended.  For example, one cluster is using the HA
> configuration and has only the HBase Master and HDFS Name Node processes
> running on two nodes.  Several questions come to mind:
>
>   1) Is the expectation those nodes will be entered at this prompt?
>
>   2) Will entering a node on this line preclude certain processes from
> running on that node, for example:
>a) Are mxosrvrs still started on those nodes?
>b) Are other Trafodion processes started on those nodes?
>
>   3) Are there other considerations as to which nodes should or should not
> be listed as management nodes?
>
>   Any insights will be helpful and appreciated.
>
> Thanks,
> Dennis
>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: RMS questions

[Gunnar Tapper]

There is a tremendous amount of documentation in the SQL Reference Guide.
For example, it contains the basic set of CQDs is documented in this
manual. Same for the other guides. For example, take a look at the odb User
Guide. It's so function rich that I am surprised that odb can't do your
taxes. :)

G.

On Wed, Mar 2, 2016 at 3:52 PM, Liu, Ming (Ming)  wrote:

> Very nice document Gunnar, I didn’t realize this. Read it through, it is
> very informational and helpful.
>
> Look very good for me, maybe Selva can review it as Gunnar suggested.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间:* 2016年3月3日 6:42
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: RMS questions
>
>
>
> Hi,
>
>
>
> Also, RMS is documented in the Trafodion SQL Reference Manual:
> http://trafodion.apache.org/docs/sql_reference/index.html#displaying_sql_runtime_statistics
>
>
>
> Selva: Please let me know if this documentation needs to be updated. If
> so, send me the info and I'll incorporate it into this guide.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Wed, Mar 2, 2016 at 3:37 PM, Liu, Ming (Ming) 
> wrote:
>
> This is very clear and good answer, solve all my confusion! I am now
> understanding how it works. Also understand the relationship among ODBC
> collected stats , repository and RMS. Thanks a lot Selva!
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间**:* 2016年3月3日 3:35
> *收件人**:* user@trafodion.incubator.apache.org
> *主题**:* RE: RMS questions
>
>
>
> Hi Ming,
>
>
>
> We are sorry for the delayed response.
>
>
>
> Please see my responses embedded.
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *Sent:* Saturday, February 27, 2016 8:05 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RMS questions
>
>
>
> Hi, all,
>
>
>
> I am trying to gather query’s run-time statistics using RMS command ‘get
> statistics’. It works fine, but I have some questions below:
>
>
>
> As I understand, RMS will save stats for a given query in shared memory,
> so it cannot save all the history. It only save CURRENT running queries’
> stats. Is this true?*[Selva] *  RMS uses the shared segment to provide
> near real time statistics of the query. The metrics are captured at the
> relevant components in near real time and updated in the shared segment
> directly while the query is being executed. RMS doesn’t poll for the
> metrics collection, it is the infrastructure to provide real time
> statistics.
>
> For a long-running query, I can start another session using ‘get
> statistics for qid xxx ‘ to periodically get the stats. For short-running
> query (finish in ms), it seems hard for me to start another session find
> out qid and run the ‘get statistics’. I think there is a small time window
> that one can still get stats for a query after it finished. *[Selva] * For
> short running queries, you can get the statistics after the query is
> completed before the next query is run in the same session using the
> command “get statistics for qid  current”.  If the query is issued
> from a non-interactive application, then you might be able to get some kind
> of summary info from Trafodion repository if it is enabled.
>
> What is that time window, 30 seconds?*[Selva]  *Generally, the statistics
> is retained till the statement is deallocated. The server deallocates the
> statement only when user initiates SQLDrop or Statement.close or the
> connection is closed or the statement object on the client side is somehow
> garbage collected and triggers resource deallocation on the server side.
> RMS extends the statistics life time a bit more till a next statement is
> prepared or executed in the same session after the statement is deallocated
>  In case of non-interactive application, this time period could be very
> short.
>
>
>
>
>
> If I have a busy system with TPS like 3000 queries/s, can RMS save all of
> them by 30 seconds? That seems huge, and memory is limited. If it works
> like a ring buffer or cache (aging out oldest entries), what is the
> strategy RMS keep stats or aging who out? *[Selva] *As I said earlier,
> RMS is an infrastructure that aids in providing the real time statistics
> and it is not statistics gathering tool. In Trafodion, Type 4 JDBC
> applications and ODBC applications use the common infrastructure DCS to
> execute the queries. DCS is capable providing the summary info or the
> detailed query statistics based on the configuration settings in DCS.
>
> What will happen if all active queries will run out of RMS memory? I

Re: 答复: RMS questions

[Gunnar Tapper]

Hi,

Also, RMS is documented in the Trafodion SQL Reference Manual:
http://trafodion.apache.org/docs/sql_reference/index.html#displaying_sql_runtime_statistics

Selva: Please let me know if this documentation needs to be updated. If so,
send me the info and I'll incorporate it into this guide.

Thanks,

Gunnar

On Wed, Mar 2, 2016 at 3:37 PM, Liu, Ming (Ming)  wrote:

> This is very clear and good answer, solve all my confusion! I am now
> understanding how it works. Also understand the relationship among ODBC
> collected stats , repository and RMS. Thanks a lot Selva!
>
>
>
> *发件人:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com]
> *发送时间:* 2016年3月3日 3:35
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* RE: RMS questions
>
>
>
> Hi Ming,
>
>
>
> We are sorry for the delayed response.
>
>
>
> Please see my responses embedded.
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming@esgyn.cn]
> *Sent:* Saturday, February 27, 2016 8:05 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RMS questions
>
>
>
> Hi, all,
>
>
>
> I am trying to gather query’s run-time statistics using RMS command ‘get
> statistics’. It works fine, but I have some questions below:
>
>
>
> As I understand, RMS will save stats for a given query in shared memory,
> so it cannot save all the history. It only save CURRENT running queries’
> stats. Is this true?*[Selva] *  RMS uses the shared segment to provide
> near real time statistics of the query. The metrics are captured at the
> relevant components in near real time and updated in the shared segment
> directly while the query is being executed. RMS doesn’t poll for the
> metrics collection, it is the infrastructure to provide real time
> statistics.
>
> For a long-running query, I can start another session using ‘get
> statistics for qid xxx ‘ to periodically get the stats. For short-running
> query (finish in ms), it seems hard for me to start another session find
> out qid and run the ‘get statistics’. I think there is a small time window
> that one can still get stats for a query after it finished. *[Selva] * For
> short running queries, you can get the statistics after the query is
> completed before the next query is run in the same session using the
> command “get statistics for qid  current”.  If the query is issued
> from a non-interactive application, then you might be able to get some kind
> of summary info from Trafodion repository if it is enabled.
>
> What is that time window, 30 seconds?*[Selva]  *Generally, the statistics
> is retained till the statement is deallocated. The server deallocates the
> statement only when user initiates SQLDrop or Statement.close or the
> connection is closed or the statement object on the client side is somehow
> garbage collected and triggers resource deallocation on the server side.
> RMS extends the statistics life time a bit more till a next statement is
> prepared or executed in the same session after the statement is deallocated
>  In case of non-interactive application, this time period could be very
> short.
>
>
>
>
>
> If I have a busy system with TPS like 3000 queries/s, can RMS save all of
> them by 30 seconds? That seems huge, and memory is limited. If it works
> like a ring buffer or cache (aging out oldest entries), what is the
> strategy RMS keep stats or aging who out? *[Selva] *As I said earlier,
> RMS is an infrastructure that aids in providing the real time statistics
> and it is not statistics gathering tool. In Trafodion, Type 4 JDBC
> applications and ODBC applications use the common infrastructure DCS to
> execute the queries. DCS is capable providing the summary info or the
> detailed query statistics based on the configuration settings in DCS.
>
> What will happen if all active queries will run out of RMS memory? I know
> we can enlarge the size of that memory, but not know exact how, any
> instructions?
>
> With the instruction, how can one calculate the required memory size if
> s/he know how many queries s/he want to save.
>
> *[Selva] *Default size of RMS shared segment is 64 MB. We have been able
> to manage within this space for hundreds of concurrent queries because RMS
> kicks in garbage collection every 10 minutes to gc any orphaned statistics
> info. Statistics can become orphaned if the server component went away
> abruptly or the server component itself failed to deallocate resources. Of
> course a badly written application that doesn’t deallocate statements can
> make RMS shared segment to become full.  RMS relies on the trusted DCS
> components /type 2 JDBC driver to put some capacity limit on the connection
> to avoid this. You can increase the RMS shared segment by adding
> MX_RTS_STATS_SEG_SIZE=  in $MY_SQROOT/etc/ms.env in all nodes and
> restarting the Trafodion instance. You can issue “get statistics for rms
> all” to confirm the size of  RMS shared segment and to get heath info of
> RMS itself.
>
> Maybe we can only save stats for ‘slow queries’?
>
>
>
> Many questions, thanks

Re: Admin Guide

[Gunnar Tapper]

Hi,

Yes, I definitely think we want to cover the ldap scripts in the admin
guide.

Thanks,

Gunnar

On Tue, Mar 1, 2016 at 5:50 PM, Roberta Marton 
wrote:

> Did you want to cover the ldapcheck script?  Not sure if it is covered in
> the *check scripts below.
>
>
>
> Roberta
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Tuesday, March 1, 2016 4:30 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Admin Guide
>
>
>
> Hi,
>
>
>
> I'm working on a Trafodion Administrator Guide.
>
>
>
> Beyond the install and *stop/*check/*start scripts, what commands/scripts
> are key to cover?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Admin Guide

[Gunnar Tapper]

Hi,

I'm starting with the basic sysadmin: starting, stopping, checking, log
files.

The DBA tasks are needed too and I'll need help with that. A good starting
point might be a list of jiras that covers such functions. Or, any other
writeups.


Thanks,

Gunnar

On Tue, Mar 1, 2016 at 5:52 PM, Carol Pearson 
wrote:

> Hi Gunnar,
>
> This will be a great addition!   Are you looking at covering
> administration of the database as well as the overall Trafodion
> environment?  Meaning things like update statistics, backups/snapshots,
> recovery, replication factors, security configuration and administration,
>  interaction with things like compaction, availability and failure
> configurations, etc.?
>
> Not all of those are "commands" or "scripts", but when I ask myself, "What
> does it take to administer Trafodion in its interactions with HBase and
> Hadoop?" these are some of the things that come to mind.
>
> The SQL Reference guide is a good place to go to understand commands, but
> as a user, I would turn to the Admin guide for the context for using these
> as I build and administer my environment.
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Tue, Mar 1, 2016 at 4:30 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> I'm working on a Trafodion Administrator Guide.
>>
>> Beyond the install and *stop/*check/*start scripts, what commands/scripts
>> are key to cover?
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Admin Guide

[Gunnar Tapper]

Hi,

I'm working on a Trafodion Administrator Guide.

Beyond the install and *stop/*check/*start scripts, what commands/scripts
are key to cover?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Logo is LIVE!

[Gunnar Tapper]

Thanks. We'll soon do another refresh to deal with some color issues as
soon as receive answers from the Reflow community on how to customize the
toolbar color; we want it to match the color of the dragon.

On Wed, Feb 24, 2016 at 2:19 PM, Atanu Mishra  wrote:

> Looks very good!
>
> The installation procedure, especially, now looks very streamlined and
> should make it easier for users to download and play with the product.
>
> Thanks Gunnar!
> Atanu
>
> 
> Atanu Mishra
>
> On Wed, Feb 24, 2016 at 11:44 AM, Amanda Moran 
> wrote:
>
>> Looks good!
>>
>> I think we made a good choice, the logo is cute!
>>
>> On Wed, Feb 24, 2016 at 11:38 AM, Gunnar Tapper 
>> wrote:
>>
>>> Please checkout the web site and the documentation PDF files.
>>>
>>> Also, we've updated the Download page with an easy-to-use installation
>>> procedure and created a Quick Start page to make it easy to try out
>>> Trafodion.
>>>
>>> Please take a look at your earliest convenience.
>>>
>>> --
>>> Thanks,
>>>
>>> Gunnar
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>>
>>
>> --
>> Thanks,
>>
>> Amanda Moran
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion Logo is LIVE!

[Gunnar Tapper]

Please checkout the web site and the documentation PDF files.

Also, we've updated the Download page with an easy-to-use installation
procedure and created a Quick Start page to make it easy to try out
Trafodion.

Please take a look at your earliest convenience.

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: [RESULT][VOTE] Apache Trafodion Logo Proposal

[Gunnar Tapper]

Hi,

Please send me the final version of the logo privately and I'll update the
website and manuals accordingly.

Thanks,

Gunnar

On Mon, Feb 22, 2016 at 4:49 PM, Roberta Marton 
wrote:

> It has been more than 72 hours and we have received many replies.
>
> Logo #13 has been approved.
>
>
>
> Voting results:
>
>
>
> +1 votes for 13: 27
>
> +1 votes for 4g: 2
>
> +0 votes: 0
>
> -1 votes: 0
>
>
>
> If my calculations are correct:
>
>
>
> 13 votes include:
>
>
>
> Roberta,  Gunnar, Hans, Sandhya, Trina, Qifan, Ming, Clr, Seth, Henry,
> Wei-shung, Rachael, Carol, Rohit, Venkat,
>
> Anu, Arvind, Dennis, Jason, Dave, Amanda, Selva, Ken, Narendra, Atanu,
> Prashanth, Sean
>
>
>
> 4g votes include:
>
>
>
> Elaine, Alex
>
>
>
> Thanks for taking time to comment on all our previous proposals and for
> voting on these last two entries.
>
> Thanks also to everyone who submitted entries and revised them from
> suggestions by our users.
>
>
>
> Regards,
>
> Roberta
>
>
>
> *From:* Roberta Marton [mailto:roberta.mar...@esgyn.com
> ]
> *Sent:* Thursday, February 18, 2016 6:02 PM
> *To:* 'user@trafodion.incubator.apache.org' <
> user@trafodion.incubator.apache.org>
> *Subject:* [VOTE] Apache Trafodion Logo Proposal
>
>
>
> There has been quite a lot of discussion on our user list regarding the
> proposed Apache Trafodion logos.
>
> It has now come time for a formal vote on the two most popular logos
> fondly known as  4g and 13.
>
> Both have been attached for your reference
>
>
>
> Please respond as follows:
>
>
>
> [ ] +1-4g approve option 4g
>
> [ ] +1-13 approve option 13
>
> [ ] +0 no opinion
>
> [ ] -1 disapprove (and reason why)
>
>
>
> The vote will be open for 72 hours.
>
>
>
>Regards,
>
>Roberta Marton
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: [VOTE] Apache Trafodion Logo Proposal

[Gunnar Tapper]

+1 for 13.

On Thu, Feb 18, 2016 at 7:03 PM, Roberta Marton 
wrote:

> +1 for 13
>
>
>
>Roberta
>
>
>
> *From:* Roberta Marton [mailto:roberta.mar...@esgyn.com]
> *Sent:* Thursday, February 18, 2016 6:02 PM
> *To:* 'user@trafodion.incubator.apache.org' <
> user@trafodion.incubator.apache.org>
> *Subject:* [VOTE] Apache Trafodion Logo Proposal
>
>
>
> There has been quite a lot of discussion on our user list regarding the
> proposed Apache Trafodion logos.
>
> It has now come time for a formal vote on the two most popular logos
> fondly known as  4g and 13.
>
> Both have been attached for your reference
>
>
>
> Please respond as follows:
>
>
>
> [ ] +1-4g approve option 4g
>
> [ ] +1-13 approve option 13
>
> [ ] +0 no opinion
>
> [ ] -1 disapprove (and reason why)
>
>
>
> The vote will be open for 72 hours.
>
>
>
>Regards,
>
>Roberta Marton
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

new logo proposal

[Gunnar Tapper]

Hi,

I know this is late but since we've not voted yet. Here's a slight
modification to logo-13, which adds an infinity symbol to the logo (the p
and d). This symbolizes the scale, HA, and usage of Trafodion: infinite. :)

[image: Inline image 1]

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: Logo Proposal

[Gunnar Tapper]

+1

On Tue, Feb 16, 2016 at 10:38 AM, Steve Varnau 
wrote:

> If “Apache” and “Trafodion” are different colors, it seems to me that
> “Trafodion” (in whatever case) should be the word that matches the color of
> the dragon. Otherwise it makes me think the dragon is trying to be the
> Apache logo.
>
>
>
> --Steve
>
>
>
> *From:* Ken Holt [mailto:knhknhknh...@gmail.com]
> *Sent:* Saturday, February 13, 2016 4:50 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: 答复: Logo Proposal
>
>
>
> Hi All,
>
>
>
> A new set of Trafodion logo options are attached, taking account of much
> of the input that I received.
>
>
>
> One of these is a clear winner for me personally, but I submit them for
> your consideration and hope we can zero in on one of them. (Or perhaps two
> for a run-off.)
>
>
>
> By the way, all logos use Google fonts, including the earlier front runner
> option 4 where I found a comparable google font to use, now named option
> 4g.
>
>
>
> Cheers, Ken
>
>
>
>
>
> On Fri, Feb 12, 2016 at 6:34 PM, Liu, Ming (Ming) 
> wrote:
>
> Thanks Gunnar,
>
>
>
> I can see it now. I like dragon very much, but hope it is not too popular.
>
> I think we also think about whale before?
>
>
>
> The meaning behind whale is: it is the biggest animal on the earth , and
> real J
>
>
>
> And Hadoop projects seem to use cute animals (Hive, Hadoop). Maybe we can
> draw a baby dragon?
>
>
>
> And most people like sky blue? I used to have black or golden dragon as my
> favorite J
>
>
>
> My 2 cents.
>
>
>
> Overall, I like this logo, it is already good enough for me. It shows to
> me how powerful Trafodion is. I know it is hard to get consensus for this
> kind of design.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间**:* 2016年2月13日 9:43
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* Re: 答复: Logo Proposal
>
>
>
> Trying an attachment...
>
>
>
> On Fri, Feb 12, 2016 at 6:26 PM, Liu, Ming (Ming) 
> wrote:
>
> Hi, Gunnar,
>
>
>
> Is it possible to put the logo as attachment? If they are not too big. I
> saw QiFan once has an attachment of a logo in one of his post. Some people
> cannot access Google drive .
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间**:* 2016年2月13日 4:31
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* Re: Logo Proposal
>
>
>
> Hi,
>
>
>
> Based on the input from several people in this thread, I'd like to propose
> the following draft as a candidate:
> https://drive.google.com/open?id=0BxlwNhWxn8iTQV85eDlyc0RxWGc
>
>
>
> I'm hoping that Ken, Sandhya, or someone else can make a real version for
> consideration rather than my PowerPoint hack. It needs a bit of work on the
> gray hue (s;lightly darker IMO), size of dragon, and alignment but that's
> better done in a real designer program. The font was downloaded from Google
> Fonts: Telex Regular.
>
>
>
> As mentioned, the draft fits into the overall website well:
> https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE and I'm
> sure it'll meet the other criteria, too.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Feb 12, 2016 at 12:39 PM, Carol Pearson <
> carol.pearson...@gmail.com> wrote:
>
> We also need our logo to look good on our customers' and users' and
> ecosystem denizens' websites so they're eager to show off that Trafodion
> fits into the puzzle ;-) .
>
>
>
> I don't think we're quite converged and ready for a real vote, and to be
> honest, I hate to call for a 3 day vote on this over a long weekend in the
> US and at the end of a holiday week in China since that's where most of our
> traffic comes from.
>
>
>
> Further discussion over the weekend and final vote on Tuesday?
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Fri, Feb 12, 2016 at 9:34 AM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
> Having Apache in our logo, brings a lot of credibility and shows we are
> serious.
>
> Let’s also keep in mind that the logo/text should look good on the
> website, presentation slides and any brochures if you will.
>

New Draft Version of the Trafodion Provisioning Guide

[Gunnar Tapper]

https://drive.google.com/open?id=0BxlwNhWxn8iTY1JSVHBia0VtbTA

Reorganized the guide a bit. Also ran spellchecker.

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: Logo Proposal

[Gunnar Tapper]

Hi Ming,

The dragon is there for the Welsh connection, which is why there was some
consensus while you folks where out on holidays.

If you want to suggest a whale, then I think you better provide the artwork
for consideration or it'll not happen. Hopefully, the dragon is OK enough
for us not to revisit the image but if you feel strong about it, then
that's the way to go.

Gunnar

On Fri, Feb 12, 2016 at 7:34 PM, Liu, Ming (Ming)  wrote:

> Thanks Gunnar,
>
>
>
> I can see it now. I like dragon very much, but hope it is not too popular.
>
> I think we also think about whale before?
>
>
>
> The meaning behind whale is: it is the biggest animal on the earth , and
> real J
>
>
>
> And Hadoop projects seem to use cute animals (Hive, Hadoop). Maybe we can
> draw a baby dragon?
>
>
>
> And most people like sky blue? I used to have black or golden dragon as my
> favorite J
>
>
>
> My 2 cents.
>
>
>
> Overall, I like this logo, it is already good enough for me. It shows to
> me how powerful Trafodion is. I know it is hard to get consensus for this
> kind of design.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间:* 2016年2月13日 9:43
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Logo Proposal
>
>
>
> Trying an attachment...
>
>
>
> On Fri, Feb 12, 2016 at 6:26 PM, Liu, Ming (Ming) 
> wrote:
>
> Hi, Gunnar,
>
>
>
> Is it possible to put the logo as attachment? If they are not too big. I
> saw QiFan once has an attachment of a logo in one of his post. Some people
> cannot access Google drive .
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间**:* 2016年2月13日 4:31
> *收件人**:* user@trafodion.incubator.apache.org
> *主题**:* Re: Logo Proposal
>
>
>
> Hi,
>
>
>
> Based on the input from several people in this thread, I'd like to propose
> the following draft as a candidate:
> https://drive.google.com/open?id=0BxlwNhWxn8iTQV85eDlyc0RxWGc
>
>
>
> I'm hoping that Ken, Sandhya, or someone else can make a real version for
> consideration rather than my PowerPoint hack. It needs a bit of work on the
> gray hue (s;lightly darker IMO), size of dragon, and alignment but that's
> better done in a real designer program. The font was downloaded from Google
> Fonts: Telex Regular.
>
>
>
> As mentioned, the draft fits into the overall website well:
> https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE and I'm
> sure it'll meet the other criteria, too.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Feb 12, 2016 at 12:39 PM, Carol Pearson <
> carol.pearson...@gmail.com> wrote:
>
> We also need our logo to look good on our customers' and users' and
> ecosystem denizens' websites so they're eager to show off that Trafodion
> fits into the puzzle ;-) .
>
>
>
> I don't think we're quite converged and ready for a real vote, and to be
> honest, I hate to call for a 3 day vote on this over a long weekend in the
> US and at the end of a holiday week in China since that's where most of our
> traffic comes from.
>
>
>
> Further discussion over the weekend and final vote on Tuesday?
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Fri, Feb 12, 2016 at 9:34 AM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
> Having Apache in our logo, brings a lot of credibility and shows we are
> serious.
>
> Let’s also keep in mind that the logo/text should look good on the
> website, presentation slides and any brochures if you will.
>
> Certainly we need multiple colors to bring attention to the product name.
>
>
>
> Venkat
>
>
>
> *From:* Christophe LeRouzo [mailto:c...@esgyn.com]
> *Sent:* Friday, February 12, 2016 7:59 AM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Rohit Jain ; Gunnar Tapper <
> tapper.gun...@gmail.com>
> *Subject:* RE: Logo Proposal
>
>
>
> It seems we might need multiple votes:
>
> -  One color or multiple colors?
>
> -  Thin font or thick font?
>
> -  One font or two fonts?
>
> -  Apache or not…
>
>
>
> What was Selva saying about engineers and votes? J
>
> -clr
>
>
>
>
>
> *From:* Amanda Moran [mailto:am

Re: 答复: 答复: Logo Proposal

[Gunnar Tapper]

Hi,

For completeness (since I care more about consistent fonts than case)...

Lowercase or not has nothing to do with professionalism. Consider the logos
of amazon, ebay, facebook, flicker, intel, hp, citibank, macy's, bp, sears,
mapquest,xerox, and so on. Many companies have switched to lowercase as
part of modernizing their logos.Why? Because they want to appear more
approachable.

Here's a nice writeup to consider:
http://www.adherecreative.com/blog/bid/181249/The-Case-for-Lower-Case-A-Rebranding-Conundrum

The branding choice isn't about personal preference but rather the
following statement: "At the end of the day, it's not a good idea to stick
to the staple just because that is what you're used to in your industry. If
you want to stand out, you have to break the mold."

You learn something new every day.

Gunnar


On Mon, Feb 15, 2016 at 12:44 PM, Carol Pearson 
wrote:

> +1 for 13
> +1 for 4g
>
> Don't like the lower case apache trafodion - I'm with Sean on that
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Mon, Feb 15, 2016 at 10:58 AM, Atanu Mishra 
> wrote:
>
>> I like 12.
>>
>> Atanu
>>
>> 
>> Atanu Mishra
>>
>> On Mon, Feb 15, 2016 at 8:03 AM, Gunnar Tapper 
>> wrote:
>>
>>> Ken: Can you make a variant of 13 with the same font as we use on the
>>> web site; that is, Telex?
>>>
>>> Thanks,
>>>
>>> Gunnar
>>>
>>> On Mon, Feb 15, 2016 at 5:33 AM, Selva Govindarajan <
>>> selva.govindara...@esgyn.com> wrote:
>>>
>>>> +1 for 8 and 13.  Consider reducing the space between the fonts if
>>>> possible in 8.
>>>>
>>>>
>>>>
>>>> Selva
>>>>
>>>>
>>>>
>>>> *From:* Ken Holt [mailto:knhknhknh...@gmail.com]
>>>> *Sent:* Saturday, February 13, 2016 4:50 PM
>>>> *To:* user@trafodion.incubator.apache.org
>>>> *Subject:* Re: 答复: 答复: Logo Proposal
>>>>
>>>>
>>>>
>>>> Hi All,
>>>>
>>>>
>>>>
>>>> A new set of Trafodion logo options are attached, taking account of
>>>> much of the input that I received.
>>>>
>>>>
>>>>
>>>> One of these is a clear winner for me personally, but I submit them for
>>>> your consideration and hope we can zero in on one of them. (Or perhaps two
>>>> for a run-off.)
>>>>
>>>>
>>>>
>>>> By the way, all logos use Google fonts, including the earlier front
>>>> runner option 4 where I found a comparable google font to use, now named
>>>> option 4g.
>>>>
>>>>
>>>>
>>>> Cheers, Ken
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Feb 12, 2016 at 6:34 PM, Liu, Ming (Ming) 
>>>> wrote:
>>>>
>>>> Thanks Gunnar,
>>>>
>>>>
>>>>
>>>> I can see it now. I like dragon very much, but hope it is not too
>>>> popular.
>>>>
>>>> I think we also think about whale before?
>>>>
>>>>
>>>>
>>>> The meaning behind whale is: it is the biggest animal on the earth ,
>>>> and real J
>>>>
>>>>
>>>>
>>>> And Hadoop projects seem to use cute animals (Hive, Hadoop). Maybe we
>>>> can draw a baby dragon?
>>>>
>>>>
>>>>
>>>> And most people like sky blue? I used to have black or golden dragon as
>>>> my favorite J
>>>>
>>>>
>>>>
>>>> My 2 cents.
>>>>
>>>>
>>>>
>>>> Overall, I like this logo, it is already good enough for me. It shows
>>>> to me how powerful Trafodion is. I know it is hard to get consensus for
>>>> this kind of design.
>>>>
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> Ming
>>>>
>>>>
>>>>
>>>> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
>>>> *发送时间**:* 2016年2月13日 9:43
>>>> *收件人**:* user@trafodion.incubator.apache.org
>>>> *主**题**:* Re: 答复: Logo Proposal
>>>>
>>&g

Re: 答复: 答复: Logo Proposal

[Gunnar Tapper]

Ken: Can you make a variant of 13 with the same font as we use on the web
site; that is, Telex?

Thanks,

Gunnar

On Mon, Feb 15, 2016 at 5:33 AM, Selva Govindarajan <
selva.govindara...@esgyn.com> wrote:

> +1 for 8 and 13.  Consider reducing the space between the fonts if
> possible in 8.
>
>
>
> Selva
>
>
>
> *From:* Ken Holt [mailto:knhknhknh...@gmail.com]
> *Sent:* Saturday, February 13, 2016 4:50 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: 答复: Logo Proposal
>
>
>
> Hi All,
>
>
>
> A new set of Trafodion logo options are attached, taking account of much
> of the input that I received.
>
>
>
> One of these is a clear winner for me personally, but I submit them for
> your consideration and hope we can zero in on one of them. (Or perhaps two
> for a run-off.)
>
>
>
> By the way, all logos use Google fonts, including the earlier front runner
> option 4 where I found a comparable google font to use, now named option
> 4g.
>
>
>
> Cheers, Ken
>
>
>
>
>
> On Fri, Feb 12, 2016 at 6:34 PM, Liu, Ming (Ming) 
> wrote:
>
> Thanks Gunnar,
>
>
>
> I can see it now. I like dragon very much, but hope it is not too popular.
>
> I think we also think about whale before?
>
>
>
> The meaning behind whale is: it is the biggest animal on the earth , and
> real J
>
>
>
> And Hadoop projects seem to use cute animals (Hive, Hadoop). Maybe we can
> draw a baby dragon?
>
>
>
> And most people like sky blue? I used to have black or golden dragon as my
> favorite J
>
>
>
> My 2 cents.
>
>
>
> Overall, I like this logo, it is already good enough for me. It shows to
> me how powerful Trafodion is. I know it is hard to get consensus for this
> kind of design.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间**:* 2016年2月13日 9:43
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* Re: 答复: Logo Proposal
>
>
>
> Trying an attachment...
>
>
>
> On Fri, Feb 12, 2016 at 6:26 PM, Liu, Ming (Ming) 
> wrote:
>
> Hi, Gunnar,
>
>
>
> Is it possible to put the logo as attachment? If they are not too big. I
> saw QiFan once has an attachment of a logo in one of his post. Some people
> cannot access Google drive .
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间**:* 2016年2月13日 4:31
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* Re: Logo Proposal
>
>
>
> Hi,
>
>
>
> Based on the input from several people in this thread, I'd like to propose
> the following draft as a candidate:
> https://drive.google.com/open?id=0BxlwNhWxn8iTQV85eDlyc0RxWGc
>
>
>
> I'm hoping that Ken, Sandhya, or someone else can make a real version for
> consideration rather than my PowerPoint hack. It needs a bit of work on the
> gray hue (s;lightly darker IMO), size of dragon, and alignment but that's
> better done in a real designer program. The font was downloaded from Google
> Fonts: Telex Regular.
>
>
>
> As mentioned, the draft fits into the overall website well:
> https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE and I'm
> sure it'll meet the other criteria, too.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Feb 12, 2016 at 12:39 PM, Carol Pearson <
> carol.pearson...@gmail.com> wrote:
>
> We also need our logo to look good on our customers' and users' and
> ecosystem denizens' websites so they're eager to show off that Trafodion
> fits into the puzzle ;-) .
>
>
>
> I don't think we're quite converged and ready for a real vote, and to be
> honest, I hate to call for a 3 day vote on this over a long weekend in the
> US and at the end of a holiday week in China since that's where most of our
> traffic comes from.
>
>
>
> Further discussion over the weekend and final vote on Tuesday?
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Fri, Feb 12, 2016 at 9:34 AM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
> Having Apache in our logo, brings a lot of credibility and shows we are
> serious.
>
> Let’s also keep in mind that the logo/text should look good on the
> website, presentation slides and any brochures if you will.
>
> Certa

Draft: Trafodion Provisioning Guide

[Gunnar Tapper]

Hi,

I've uploaded a draft version of the Trafodion Provisioning Guide to:
https://drive.google.com/open?id=0BxlwNhWxn8iTRXpJaHdyWGxpVWM

I still have to populate the Upgrade chapter and complete the instructions
for recipe-based provisioning. I will be working on such instructions over
the next few days.

Troubleshooting instructions are missing at this point. Hopefully, these
can be added over time.

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Logo Proposal

[Gunnar Tapper]

It's better to stand out as long as it doesn't violates some rule... :)
Carol might know the answer to whether lowercase does.

On Fri, Feb 12, 2016 at 1:37 PM, Sean Broeder 
wrote:

> I know there has been some talk of using lower case in Trafodion, but do
> we want to extend that to Apache?  I’ve done some non-exhaustive searches
> and can’t find any instance where the leading ‘A’ is not capitalized.  I
> think we should follow that pattern.
>
>
>
> Regards,
>
> Sean
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Friday, February 12, 2016 12:31 PM
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Logo Proposal
>
>
>
> Hi,
>
>
>
> Based on the input from several people in this thread, I'd like to propose
> the following draft as a candidate:
> https://drive.google.com/open?id=0BxlwNhWxn8iTQV85eDlyc0RxWGc
>
>
>
> I'm hoping that Ken, Sandhya, or someone else can make a real version for
> consideration rather than my PowerPoint hack. It needs a bit of work on the
> gray hue (s;lightly darker IMO), size of dragon, and alignment but that's
> better done in a real designer program. The font was downloaded from Google
> Fonts: Telex Regular.
>
>
>
> As mentioned, the draft fits into the overall website well:
> https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE and I'm
> sure it'll meet the other criteria, too.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
>
>
>
>
>
>
>
>
> On Fri, Feb 12, 2016 at 12:39 PM, Carol Pearson <
> carol.pearson...@gmail.com> wrote:
>
> We also need our logo to look good on our customers' and users' and
> ecosystem denizens' websites so they're eager to show off that Trafodion
> fits into the puzzle ;-) .
>
>
>
> I don't think we're quite converged and ready for a real vote, and to be
> honest, I hate to call for a 3 day vote on this over a long weekend in the
> US and at the end of a holiday week in China since that's where most of our
> traffic comes from.
>
>
>
> Further discussion over the weekend and final vote on Tuesday?
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Fri, Feb 12, 2016 at 9:34 AM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
> Having Apache in our logo, brings a lot of credibility and shows we are
> serious.
>
> Let’s also keep in mind that the logo/text should look good on the
> website, presentation slides and any brochures if you will.
>
> Certainly we need multiple colors to bring attention to the product name.
>
>
>
> Venkat
>
>
>
> *From:* Christophe LeRouzo [mailto:c...@esgyn.com]
> *Sent:* Friday, February 12, 2016 7:59 AM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Rohit Jain ; Gunnar Tapper <
> tapper.gun...@gmail.com>
> *Subject:* RE: Logo Proposal
>
>
>
> It seems we might need multiple votes:
>
> -  One color or multiple colors?
>
> -  Thin font or thick font?
>
> -  One font or two fonts?
>
> -  Apache or not…
>
>
>
> What was Selva saying about engineers and votes? J
>
> -clr
>
>
>
>
>
> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com]
> *Sent:* Friday, February 12, 2016 7:21 AM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Rohit ; Gunnar Tapper  >
> *Subject:* Re: Logo Proposal
>
>
>
> -1 all same color.
>
>
>
> I still like option 4 the way it was/is but I can understand wanting to
> remove Apache  But I still like it the way it is
>
>
>
> Sent from my iPhone
>
>
> On Feb 12, 2016, at 7:15 AM, Qifan Chen  wrote:
>
> But is it obvious that Trafodion is an Apache project, if one starts to
> read about it?
>
>
>
> On Fri, Feb 12, 2016 at 8:48 AM, Rohit  wrote:
>
> It depends on how much value you think Apache adds to Trafodion, as
> compared to those other logos that perhaps already have some cachet.  I
> feel that it adds quite a bit of value to Trafodion.
>
>
>
> Rohit
>
>
>
>  Original message 
> From: Qifan Chen 
> Date: 02/12/2016 8:34 AM (GMT-06:00)
> To: user@trafodion.incubator.apache.org
>
> Cc: Gunnar Tapper 
> Subject: Re: Logo Proposal
>
> I wonder if we could also consider a mod to option 4 where only the dragon
> and the word trafodion are present. See the two images attached.
>
&

Re: Logo Proposal

[Gunnar Tapper]

Hi,

Based on the input from several people in this thread, I'd like to propose
the following draft as a candidate:
https://drive.google.com/open?id=0BxlwNhWxn8iTQV85eDlyc0RxWGc

I'm hoping that Ken, Sandhya, or someone else can make a real version for
consideration rather than my PowerPoint hack. It needs a bit of work on the
gray hue (s;lightly darker IMO), size of dragon, and alignment but that's
better done in a real designer program. The font was downloaded from Google
Fonts: Telex Regular.

As mentioned, the draft fits into the overall website well:
https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE and I'm sure
it'll meet the other criteria, too.

Thanks,

Gunnar





On Fri, Feb 12, 2016 at 12:39 PM, Carol Pearson 
wrote:

> We also need our logo to look good on our customers' and users' and
> ecosystem denizens' websites so they're eager to show off that Trafodion
> fits into the puzzle ;-) .
>
> I don't think we're quite converged and ready for a real vote, and to be
> honest, I hate to call for a 3 day vote on this over a long weekend in the
> US and at the end of a holiday week in China since that's where most of our
> traffic comes from.
>
> Further discussion over the weekend and final vote on Tuesday?
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Fri, Feb 12, 2016 at 9:34 AM, Venkat Muthuswamy <
> venkat.muthusw...@esgyn.com> wrote:
>
>> Having Apache in our logo, brings a lot of credibility and shows we are
>> serious.
>>
>> Let’s also keep in mind that the logo/text should look good on the
>> website, presentation slides and any brochures if you will.
>>
>> Certainly we need multiple colors to bring attention to the product name.
>>
>>
>>
>> Venkat
>>
>>
>>
>> *From:* Christophe LeRouzo [mailto:c...@esgyn.com]
>> *Sent:* Friday, February 12, 2016 7:59 AM
>> *To:* user@trafodion.incubator.apache.org
>> *Cc:* Rohit Jain ; Gunnar Tapper <
>> tapper.gun...@gmail.com>
>> *Subject:* RE: Logo Proposal
>>
>>
>>
>> It seems we might need multiple votes:
>>
>> -  One color or multiple colors?
>>
>> -  Thin font or thick font?
>>
>> -      One font or two fonts?
>>
>> -  Apache or not…
>>
>>
>>
>> What was Selva saying about engineers and votes? J
>>
>> -clr
>>
>>
>>
>>
>>
>> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com]
>> *Sent:* Friday, February 12, 2016 7:21 AM
>> *To:* user@trafodion.incubator.apache.org
>> *Cc:* Rohit ; Gunnar Tapper <
>> tapper.gun...@gmail.com>
>> *Subject:* Re: Logo Proposal
>>
>>
>>
>> -1 all same color.
>>
>>
>>
>> I still like option 4 the way it was/is but I can understand wanting to
>> remove Apache  But I still like it the way it is
>>
>>
>>
>> Sent from my iPhone
>>
>>
>> On Feb 12, 2016, at 7:15 AM, Qifan Chen  wrote:
>>
>> But is it obvious that Trafodion is an Apache project, if one starts to
>> read about it?
>>
>>
>>
>> On Fri, Feb 12, 2016 at 8:48 AM, Rohit  wrote:
>>
>> It depends on how much value you think Apache adds to Trafodion, as
>> compared to those other logos that perhaps already have some cachet.  I
>> feel that it adds quite a bit of value to Trafodion.
>>
>>
>>
>> Rohit
>>
>>
>>
>>  Original message 
>> From: Qifan Chen 
>> Date: 02/12/2016 8:34 AM (GMT-06:00)
>> To: user@trafodion.incubator.apache.org
>>
>> Cc: Gunnar Tapper 
>> Subject: Re: Logo Proposal
>>
>> I wonder if we could also consider a mod to option 4 where only the
>> dragon and the word trafodion are present. See the two images attached.
>>
>>
>>
>> I sampled a couple apache project logs and found they do not have the
>> word APACHE in their logos (e.g., HIVE, MONGODB, AVRO, SPARK).
>>
>>
>>
>> With this approach, it is possible to put the Trafodion logo into the
>> "power by Apache" logo, see URL here
>> <http://www.apache.org/foundation/press/kit/>, without the duplication
>> of "Apache".
>>
>>
>>
>> It also simplifies the design and allows a good focus.
>>
>>
>>
>> Thanks --Qifan
>>
>>
>>
>> On 

Re: Logo Proposal

[Gunnar Tapper]

Just make sure it with the web site and it's all good. :)

On Fri, Feb 12, 2016 at 9:01 AM, Sandhya Sundaresan <
sandhya.sundare...@esgyn.com> wrote:

> Nope. We just need more choices to vote. We have to definitely keep option
> 4 on the list.  It’s still the most popular so far . Then lets see if it
> continues to be the most popular after the variations suggested by others.
>
> No we cannot vote on individual attributes – the whole package may look
> different !
>
>
>
> *From:* Christophe LeRouzo [mailto:c...@esgyn.com]
> *Sent:* Friday, February 12, 2016 7:59 AM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Rohit Jain ; Gunnar Tapper <
> tapper.gun...@gmail.com>
> *Subject:* RE: Logo Proposal
>
>
>
> It seems we might need multiple votes:
>
> -  One color or multiple colors?
>
> -  Thin font or thick font?
>
> -  One font or two fonts?
>
> -  Apache or not…
>
>
>
> What was Selva saying about engineers and votes? J
>
> -clr
>
>
>
>
>
> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com]
> *Sent:* Friday, February 12, 2016 7:21 AM
> *To:* user@trafodion.incubator.apache.org
> *Cc:* Rohit ; Gunnar Tapper  >
> *Subject:* Re: Logo Proposal
>
>
>
> -1 all same color.
>
>
>
> I still like option 4 the way it was/is but I can understand wanting to
> remove Apache  But I still like it the way it is
>
>
>
> Sent from my iPhone
>
>
> On Feb 12, 2016, at 7:15 AM, Qifan Chen  wrote:
>
> But is it obvious that Trafodion is an Apache project, if one starts to
> read about it?
>
>
>
> On Fri, Feb 12, 2016 at 8:48 AM, Rohit  wrote:
>
> It depends on how much value you think Apache adds to Trafodion, as
> compared to those other logos that perhaps already have some cachet.  I
> feel that it adds quite a bit of value to Trafodion.
>
>
>
> Rohit
>
>
>
>  Original message 
> From: Qifan Chen 
> Date: 02/12/2016 8:34 AM (GMT-06:00)
> To: user@trafodion.incubator.apache.org
>
> Cc: Gunnar Tapper 
> Subject: Re: Logo Proposal
>
> I wonder if we could also consider a mod to option 4 where only the dragon
> and the word trafodion are present. See the two images attached.
>
>
>
> I sampled a couple apache project logs and found they do not have the word
> APACHE in their logos (e.g., HIVE, MONGODB, AVRO, SPARK).
>
>
>
> With this approach, it is possible to put the Trafodion logo into the
> "power by Apache" logo, see URL here
> <http://www.apache.org/foundation/press/kit/>, without the duplication of
> "Apache".
>
>
>
> It also simplifies the design and allows a good focus.
>
>
>
> Thanks --Qifan
>
>
>
> On Fri, Feb 12, 2016 at 7:19 AM, Rohit  wrote:
>
> -1
>
>
>
> Check out the other logos I sent to the internal dlist.
>
>
>
> Rohit
>
>
>
>  Original message 
> From: Gunnar Tapper 
> Date: 02/12/2016 12:50 AM (GMT-06:00)
> To: user@trafodion.incubator.apache.org
> Subject: Re: Logo Proposal
>
> Hi,
>
>
>
> I suggest that we limit the number of colors used.
>
>
>
> A simple change:
> https://drive.google.com/open?id=0BxlwNhWxn8iTT3NNMTZ0dmhqQm8
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Thu, Feb 11, 2016 at 8:52 PM, Trina Krug  wrote:
>
> Option 4!!
>
>
>
> Trina
>
>
> On Feb 11, 2016, at 7:05 PM, Carol Pearson 
> wrote:
>
> Slightly late to the party, but +1 on option 4 as well.  Though I would
> prefer a slightly less formal font, the one in option 6 is too spaced out
> and I'm not fond of it overall...
>
>
>
> But that's really a nit and this is infinitely better than no logo at
> all
>
>
>
> Thanks Ken!
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Thu, Feb 11, 2016 at 5:41 PM, Gunnar Tapper 
> wrote:
>
> Neither. Keep the font the same for Apache and Trafodion. Bold them both.
>
>
>
> On Thu, Feb 11, 2016 at 4:16 PM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> Perhaps we should try and see how lowercase with both placements look. The
> dragon on top looks better to many. We can take votes again J
>
>
>
> *From:* Wei-Shiun Tsai [mailto:wei-shiun.t...@esgyn.com]
> *Sent:* Thursday, February 11, 2016 3:13 PM
>
>
> *To:* user@trafodion.incubator.apache.org
> *

Re: Logo Proposal

[Gunnar Tapper]

Hi,

As stated, we need to look at this on the website to see what works. The
fonts used for #4 are problematic in that context and for reading in
generar. Variants using the Telex font (same as the headers on the website)
in different variants:
https://drive.google.com/open?id=0BxlwNhWxn8iTTVBDZGVaOGdoYU0

If using two colors on the text:
https://drive.google.com/open?id=0BxlwNhWxn8iTRW9lSThBSmstYm8

I'd tone down the black a bit so it fits in better in context:
https://drive.google.com/open?id=0BxlwNhWxn8iTczNMLTRjYUVXSkE



On Fri, Feb 12, 2016 at 8:21 AM, Amanda Moran 
wrote:

> -1 all same color.
>
> I still like option 4 the way it was/is but I can understand wanting to
> remove Apache  But I still like it the way it is
>
> Sent from my iPhone
>
> On Feb 12, 2016, at 7:15 AM, Qifan Chen  wrote:
>
> But is it obvious that Trafodion is an Apache project, if one starts to
> read about it?
>
> On Fri, Feb 12, 2016 at 8:48 AM, Rohit  wrote:
>
>> It depends on how much value you think Apache adds to Trafodion, as
>> compared to those other logos that perhaps already have some cachet.  I
>> feel that it adds quite a bit of value to Trafodion.
>>
>> Rohit
>>
>>
>>  Original message 
>> From: Qifan Chen 
>> Date: 02/12/2016 8:34 AM (GMT-06:00)
>> To: user@trafodion.incubator.apache.org
>> Cc: Gunnar Tapper 
>> Subject: Re: Logo Proposal
>>
>> I wonder if we could also consider a mod to option 4 where only the
>> dragon and the word trafodion are present. See the two images attached.
>>
>> I sampled a couple apache project logs and found they do not have the
>> word APACHE in their logos (e.g., HIVE, MONGODB, AVRO, SPARK).
>>
>> With this approach, it is possible to put the Trafodion logo into the
>> "power by Apache" logo, see URL here
>> <http://www.apache.org/foundation/press/kit/>, without the duplication
>> of "Apache".
>>
>> It also simplifies the design and allows a good focus.
>>
>> Thanks --Qifan
>>
>> On Fri, Feb 12, 2016 at 7:19 AM, Rohit  wrote:
>>
>>> -1
>>>
>>> Check out the other logos I sent to the internal dlist.
>>>
>>> Rohit
>>>
>>>
>>>  Original message 
>>> From: Gunnar Tapper 
>>> Date: 02/12/2016 12:50 AM (GMT-06:00)
>>> To: user@trafodion.incubator.apache.org
>>> Subject: Re: Logo Proposal
>>>
>>> Hi,
>>>
>>> I suggest that we limit the number of colors used.
>>>
>>> A simple change:
>>> https://drive.google.com/open?id=0BxlwNhWxn8iTT3NNMTZ0dmhqQm8
>>>
>>> Thanks,
>>>
>>> Gunnar
>>>
>>> On Thu, Feb 11, 2016 at 8:52 PM, Trina Krug 
>>> wrote:
>>>
>>>> Option 4!!
>>>>
>>>> Trina
>>>>
>>>> On Feb 11, 2016, at 7:05 PM, Carol Pearson 
>>>> wrote:
>>>>
>>>> Slightly late to the party, but +1 on option 4 as well.  Though I would
>>>> prefer a slightly less formal font, the one in option 6 is too spaced out
>>>> and I'm not fond of it overall...
>>>>
>>>> But that's really a nit and this is infinitely better than no logo at
>>>> all
>>>>
>>>> Thanks Ken!
>>>>
>>>> -Carol P.
>>>>
>>>> ---
>>>> Email:carol.pearson...@gmail.com
>>>> Twitter:  @CarolP222
>>>> ---
>>>>
>>>> On Thu, Feb 11, 2016 at 5:41 PM, Gunnar Tapper >>> > wrote:
>>>>
>>>>> Neither. Keep the font the same for Apache and Trafodion. Bold them
>>>>> both.
>>>>>
>>>>> On Thu, Feb 11, 2016 at 4:16 PM, Sandhya Sundaresan <
>>>>> sandhya.sundare...@esgyn.com> wrote:
>>>>>
>>>>>> Perhaps we should try and see how lowercase with both placements
>>>>>> look. The dragon on top looks better to many. We can take votes again
>>>>>> J
>>>>>>
>>>>>>
>>>>>>
>>>>>> *From:* Wei-Shiun Tsai [mailto:wei-shiun.t...@esgyn.com]
>>>>>> *Sent:* Thursday, February 11, 2016 3:13 PM
>>>>>>
>>>>>> *To:* user@trafodion.incubator.apache.org
>>>>>> *Subject:* RE: Logo Proposal
>>>>>>
&g

Re: Logo Proposal

[Gunnar Tapper]

Hi,

I tried logo option #4 on the website. Screenshot located at:
https://drive.google.com/open?id=0BxlwNhWxn8iTZ0FFM2I0WnpwWlE

As you can see, the dragon itself works well due to the fact that the bulk
of the body is of a darker blue.

Alas, the font family doesn't work well with Telex (
https://www.google.com/fonts/specimen/Telex), which is what the web site
uses via the bootswatch theme. Overall, the font in the logo would be too
hard to read if applied to the overall website.

The light-blue color on the word "Apache" doesn't work either; it's better
to use the dark color from the dragon's body. The
"Transactional-SQL-on-Hadoop" slogan is lost due to the black font color of
"Trafodion", which is why I suggest a singular color for all of "Apache
Trafodion" — it's easy to add slogans underneath the logo with text that
way.

To me, this experiment validates that the logo itself is fine but there's a
little more work on the text associated with the logo to finish the job. I
am not suggesting to use the font in my earlier mockup but would like to
try Telex together with the darker text to see how that fits. It's too late
for me to try that experiment at this time so maybe tomorrow.

My two cents,

Gunnar

On Thu, Feb 11, 2016 at 11:50 PM, Gunnar Tapper 
wrote:

> Hi,
>
> I suggest that we limit the number of colors used.
>
> A simple change:
> https://drive.google.com/open?id=0BxlwNhWxn8iTT3NNMTZ0dmhqQm8
>
> Thanks,
>
> Gunnar
>
> On Thu, Feb 11, 2016 at 8:52 PM, Trina Krug  wrote:
>
>> Option 4!!
>>
>> Trina
>>
>> On Feb 11, 2016, at 7:05 PM, Carol Pearson 
>> wrote:
>>
>> Slightly late to the party, but +1 on option 4 as well.  Though I would
>> prefer a slightly less formal font, the one in option 6 is too spaced out
>> and I'm not fond of it overall...
>>
>> But that's really a nit and this is infinitely better than no logo at
>> all
>>
>> Thanks Ken!
>>
>> -Carol P.
>>
>> -------
>> Email:carol.pearson...@gmail.com
>> Twitter:  @CarolP222
>> ---
>>
>> On Thu, Feb 11, 2016 at 5:41 PM, Gunnar Tapper 
>> wrote:
>>
>>> Neither. Keep the font the same for Apache and Trafodion. Bold them both.
>>>
>>> On Thu, Feb 11, 2016 at 4:16 PM, Sandhya Sundaresan <
>>> sandhya.sundare...@esgyn.com> wrote:
>>>
>>>> Perhaps we should try and see how lowercase with both placements look.
>>>> The dragon on top looks better to many. We can take votes again J
>>>>
>>>>
>>>>
>>>> *From:* Wei-Shiun Tsai [mailto:wei-shiun.t...@esgyn.com]
>>>> *Sent:* Thursday, February 11, 2016 3:13 PM
>>>>
>>>> *To:* user@trafodion.incubator.apache.org
>>>> *Subject:* RE: Logo Proposal
>>>>
>>>>
>>>>
>>>> +1 for Dave’s and Hans’ suggestion.  Like the dragon to sit on the
>>>> right, not on top of Trafodion.  But the font in #4 looks more professional
>>>> (perhaps also in lower case).
>>>>
>>>>
>>>>
>>>> Weishiun
>>>>
>>>>
>>>>
>>>> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
>>>> *Sent:* Thursday, February 11, 2016 3:04 PM
>>>> *To:* user@trafodion.incubator.apache.org
>>>> *Subject:* RE: Logo Proposal
>>>>
>>>>
>>>>
>>>> Hi,
>>>>
>>>>
>>>>
>>>> I like the font for option 4 (perhaps lower cased as Hans mentioned),
>>>> but with the placement of option 6.
>>>>
>>>>
>>>>
>>>> That said, either one is fine.
>>>>
>>>>
>>>>
>>>> Dave
>>>>
>>>>
>>>>
>>>> *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com]
>>>> *Sent:* Thursday, February 11, 2016 3:02 PM
>>>> *To:* user@trafodion.incubator.apache.org
>>>> *Subject:* RE: Logo Proposal
>>>>
>>>>
>>>>
>>>> +1 option 4
>>>>
>>>>
>>>>
>>>> *From:* Anuradha Hegde [mailto:anuradha.he...@esgyn.com]
>>>> *Sent:* Thursday, February 11, 2016 4:57 PM
>>>> *To:* user@trafodion.incubator.apache.org
>>>> *Subject:* RE: Logo Proposal
>>>>
>>>>
>>>>
>>>> +1 option 4
>>>&

Re: Logo Proposal

[Gunnar Tapper]

Hi,

I suggest that we limit the number of colors used.

A simple change:
https://drive.google.com/open?id=0BxlwNhWxn8iTT3NNMTZ0dmhqQm8

Thanks,

Gunnar

On Thu, Feb 11, 2016 at 8:52 PM, Trina Krug  wrote:

> Option 4!!
>
> Trina
>
> On Feb 11, 2016, at 7:05 PM, Carol Pearson 
> wrote:
>
> Slightly late to the party, but +1 on option 4 as well.  Though I would
> prefer a slightly less formal font, the one in option 6 is too spaced out
> and I'm not fond of it overall...
>
> But that's really a nit and this is infinitely better than no logo at
> all
>
> Thanks Ken!
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> -------
>
> On Thu, Feb 11, 2016 at 5:41 PM, Gunnar Tapper 
> wrote:
>
>> Neither. Keep the font the same for Apache and Trafodion. Bold them both.
>>
>> On Thu, Feb 11, 2016 at 4:16 PM, Sandhya Sundaresan <
>> sandhya.sundare...@esgyn.com> wrote:
>>
>>> Perhaps we should try and see how lowercase with both placements look.
>>> The dragon on top looks better to many. We can take votes again J
>>>
>>>
>>>
>>> *From:* Wei-Shiun Tsai [mailto:wei-shiun.t...@esgyn.com]
>>> *Sent:* Thursday, February 11, 2016 3:13 PM
>>>
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* RE: Logo Proposal
>>>
>>>
>>>
>>> +1 for Dave’s and Hans’ suggestion.  Like the dragon to sit on the
>>> right, not on top of Trafodion.  But the font in #4 looks more professional
>>> (perhaps also in lower case).
>>>
>>>
>>>
>>> Weishiun
>>>
>>>
>>>
>>> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
>>> *Sent:* Thursday, February 11, 2016 3:04 PM
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* RE: Logo Proposal
>>>
>>>
>>>
>>> Hi,
>>>
>>>
>>>
>>> I like the font for option 4 (perhaps lower cased as Hans mentioned),
>>> but with the placement of option 6.
>>>
>>>
>>>
>>> That said, either one is fine.
>>>
>>>
>>>
>>> Dave
>>>
>>>
>>>
>>> *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com]
>>> *Sent:* Thursday, February 11, 2016 3:02 PM
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* RE: Logo Proposal
>>>
>>>
>>>
>>> +1 option 4
>>>
>>>
>>>
>>> *From:* Anuradha Hegde [mailto:anuradha.he...@esgyn.com]
>>> *Sent:* Thursday, February 11, 2016 4:57 PM
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* RE: Logo Proposal
>>>
>>>
>>>
>>> +1 option 4
>>>
>>>
>>>
>>> *From:* Ken Holt [mailto:knhknhknh...@gmail.com]
>>> *Sent:* Thursday, February 11, 2016 2:51 PM
>>> *To:* user@trafodion.incubator.apache.org
>>> *Subject:* Re: Logo Proposal
>>>
>>>
>>>
>>> Seems like the dragon logo itself is a winner - most everyone liked that.
>>>
>>> But the combined logo and name was definitely not popular.
>>>
>>>
>>>
>>> Here are a couple of new suggestions for the combined logo and name.
>>>
>>>
>>>
>>> Option 4
>>>
>>>
>>> https://drive.google.com/file/d/0B9c1EkzsNnw4T3o3YVBDakNtQkU/view?usp=sharing
>>>
>>>
>>>
>>> Option 6
>>>
>>>
>>> https://drive.google.com/file/d/0B9c1EkzsNnw4Y082OHhNNXBwazA/view?usp=sharing
>>>
>>>
>>>
>>> Don't ask for options 1-3, & 5 - they didn't make it passed my limited
>>> field testing!
>>>
>>> Comments on 4 & 6?
>>>
>>>
>>>
>>> Cheers, Ken
>>>
>>>
>>>
>>> On Tue, Feb 9, 2016 at 4:03 PM, Sandhya Sundaresan <
>>> sandhya.sundare...@esgyn.com> wrote:
>>>
>>> I’d say there is enough “curliness” going on with the dragon. So  we
>>> could try with a simple bold font  . Perhaps with an outline of a different
>>> color like Hadoop’s/Mahouts is and tie it in with the dragon’s colors as
>>> well.
>>>
>>>
>>>
>>> *From:* Hans Zeller [mailto:hans.zel...@esgyn.com]
>>> *Sent:* Tuesday, February 9, 

Re: Trafodion Runtime Security

[Gunnar Tapper]

I'll bite. Do the traditional Posix bits work under Trafodion?

Gunnar

On Wed, Feb 10, 2016 at 7:56 PM, Qifan Chen  wrote:

> Should we also briefly mention if the traditional Posix permission bits
> does/does not work under trafodion?
>
> thanks --Qifan
>
> On Wed, Feb 10, 2016 at 8:16 PM, Hans Zeller 
> wrote:
>
>> Hi Gunnar, sounds good to me. Two somewhat related comments: One is that
>> if Trafodion uses a floating IP address in a cloud deployment, like Amazon
>> AWS, the trafodion id will need limited sudo capabilities to move the
>> elastic IP address from one node to another.
>>
>> The other is what we should not do: The trafodion id should not be given
>> any other sudo privileges. Also, the trafodion id should be locked (sudo
>> passwd -l trafodion). Users who need to be running as the trafodion id
>> should do that using the sudo command, e.g. sudo -u trafodion -i.
>>
>> Thanks,
>>
>> Hans
>>
>> On Fri, Feb 5, 2016 at 1:57 PM, Gunnar Tapper 
>> wrote:
>>
>>> Hi,
>>>
>>> I'm trying to document introductory-level security requirements for
>>> Trafodion, both runtime and during provisining
>>> (installation/upgrade/resizing/removal).
>>>
>>> This is what I have for runtime:
>>>
>>> The `trafodion:trafodion` user ID is created as part of the installation
>>> process. Trafodion runs under this ID, which must be
>>> registered as a user in the Hadoop Distributed File System (HDFS) to
>>> store and access objects in HDFS, HBase, and Hive.
>>> In addition, the `trafodion` user ID required passwordless access among
>>> the nodes where Trafodion is installed to run cross-node Trafodion
>>> functions such as scripts.
>>>
>>> Trafodion requires that either HDFS ACLs or Kerberos is enabled.
>>>
>>> Trafodion users are managed by the Trafodion SQL security features
>>> (grant, revoke, etc.), which can be integrated with LDAP if so desired.
>>> These users are referred to as *database users* and do not have direct
>>> access to the operating system.
>>>
>>>
>>> What did I miss? What did I get wrong?
>>>
>>> --
>>> Thanks,
>>>
>>> Gunnar
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>>
>
>
> --
> Regards, --Qifan
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Logo Proposal

[Gunnar Tapper]

Neither. Keep the font the same for Apache and Trafodion. Bold them both.

On Thu, Feb 11, 2016 at 4:16 PM, Sandhya Sundaresan <
sandhya.sundare...@esgyn.com> wrote:

> Perhaps we should try and see how lowercase with both placements look. The
> dragon on top looks better to many. We can take votes again J
>
>
>
> *From:* Wei-Shiun Tsai [mailto:wei-shiun.t...@esgyn.com]
> *Sent:* Thursday, February 11, 2016 3:13 PM
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Logo Proposal
>
>
>
> +1 for Dave’s and Hans’ suggestion.  Like the dragon to sit on the right,
> not on top of Trafodion.  But the font in #4 looks more professional
> (perhaps also in lower case).
>
>
>
> Weishiun
>
>
>
> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
> *Sent:* Thursday, February 11, 2016 3:04 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Logo Proposal
>
>
>
> Hi,
>
>
>
> I like the font for option 4 (perhaps lower cased as Hans mentioned), but
> with the placement of option 6.
>
>
>
> That said, either one is fine.
>
>
>
> Dave
>
>
>
> *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com]
> *Sent:* Thursday, February 11, 2016 3:02 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Logo Proposal
>
>
>
> +1 option 4
>
>
>
> *From:* Anuradha Hegde [mailto:anuradha.he...@esgyn.com]
> *Sent:* Thursday, February 11, 2016 4:57 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Logo Proposal
>
>
>
> +1 option 4
>
>
>
> *From:* Ken Holt [mailto:knhknhknh...@gmail.com]
> *Sent:* Thursday, February 11, 2016 2:51 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Logo Proposal
>
>
>
> Seems like the dragon logo itself is a winner - most everyone liked that.
>
> But the combined logo and name was definitely not popular.
>
>
>
> Here are a couple of new suggestions for the combined logo and name.
>
>
>
> Option 4
>
>
> https://drive.google.com/file/d/0B9c1EkzsNnw4T3o3YVBDakNtQkU/view?usp=sharing
>
>
>
> Option 6
>
>
> https://drive.google.com/file/d/0B9c1EkzsNnw4Y082OHhNNXBwazA/view?usp=sharing
>
>
>
> Don't ask for options 1-3, & 5 - they didn't make it passed my limited
> field testing!
>
> Comments on 4 & 6?
>
>
>
> Cheers, Ken
>
>
>
> On Tue, Feb 9, 2016 at 4:03 PM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> I’d say there is enough “curliness” going on with the dragon. So  we could
> try with a simple bold font  . Perhaps with an outline of a different color
> like Hadoop’s/Mahouts is and tie it in with the dragon’s colors as well.
>
>
>
> *From:* Hans Zeller [mailto:hans.zel...@esgyn.com]
> *Sent:* Tuesday, February 9, 2016 3:46 PM
>
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Logo Proposal
>
>
>
> +1 for the dragon as well. We used to have an informal logo with another
> somewhat cursive font, it shows in one of the carousel pictures on the
> trafodion.apache.org site. That might be better (although still not my
> favorite).
>
>
> Hans
>
>
>
> On Tue, Feb 9, 2016 at 11:52 AM, Ken Holt  wrote:
>
> By the way, the size of the example logo is arbitrary.  The original is a
> vector graphics file that will scale up or down with no loss of quality,
> which I will make available when the debate has settled on something.
>
>
>
> I'll make a stab at changing the font and size relative to the dragon and
> post another version of that.
>
>
>
> Agree that separating the dragon from the name/font makes sense.
>
> Cheers, Ken
>
>
>
>
>
> On Tue, Feb 9, 2016 at 11:49 AM, Stack  wrote:
>
> +1 on dragon.
>
>
>
> On Tue, Feb 9, 2016 at 11:19 AM, Carol Pearson 
> wrote:
>
> +1 on the Dragon!!!  Looks great!
>
>
>
> On the writing, cursive is hard to read, so I'm up for replacing it
> separately.  Maybe we vote on each separately (as Sandhya and Amanda did)?
>
>
>
>
>
> Voting separately is a good idea. Having engineers vote on 'designs' is
> always a tough one. Sounds like folks like the dragon but not the
> cursive... so suggest splitting out what we vote on so at least the dragon
> carries.
>
>
>
> St.Ack
>
>
>
>
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Tue, Feb 9, 2016 at 10:15 AM, Sandhya Sundaresan <
> sandhya.sundare...@esgyn.com> wrote:
>
> +1 for Dragon.
>
> The Trafodion cursive writing and color  -1. IMHO we need to rework the
> writing for sure and try various colors. It’s looking cluttered and
> complicated with the cursive.
>
>
>
>
>
> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com]
> *Sent:* Tuesday, February 9, 2016 10:13 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Logo Proposal
>
>
>
> +10 for dragon! Very cute!
>
>
>
> Not a huge fan of the cursive writing myself... but if everyone else
> likes... I give it a +0
>
>
>
> On Tue, Feb 9, 2016 at 10:00 AM, Christophe LeRouzo 
> wrote:
>
> Thanks Ken, the standalone

Re: Hyperthreading

[Gunnar Tapper]

I believe that this check is in the "doesn't work" category and should,
therefore, be removed as part of an overall review of the scanner
configuration...

On Wed, Feb 10, 2016 at 4:00 PM, D. Markt  wrote:

> Hi,
>
>
>
>   I believe years ago when testing the precursor product to Trafodion,
> which included components not currently part of Trafodion, testing with
> Hyperthreading on encountered unexpected/different from HT off results (I’m
> not sure exactly what was encountered).  Given how long ago that was, both
> HT and that product on Linux were immature and it could have been a bug at
> any level of the stack or maybe the results were just misinterpreted and
> there were other issues to resolve that using HT for that product was not a
> priority.
>
>
>
>   That’s right, not everyone, especially when HT was introduced, believed
> (or even today believes) using HT is the right thing to do.  Even the Intel
> web page (
> http://www.intel.com/content/www/us/en/architecture-and-technology/hyper-threading/hyper-threading-technology.html)
> says “Performance will vary depending on the specific hardware and
> software used. ”  Other web pages imply there can be performance loss but
> those pages tend to be older.  Some point out how it can be harder to
> interpret CPU utilization given many tools will see 2x the number of actual
> cores even though there is not actually twice the processing power per se.
>
>
>
>   With all that said, I have been involved with testing Trafodion on
> systems with and without HT enabled using several different benchmarks and
> Trafodion runs fine in both environments.  Given the Region Server is often
> one of the heaviest users of the CPU and is multi-threaded all the
> benchmark results I can recall at the moment were helped by having HT on
> save for one.  It was a variant of one of the benchmarks and the drop was
> significant enough with HT on that it wasn’t run variance.  There was one
> other test result where HT on was slightly less than with HT off but it
> could have been run variance.
>
>
>
>   So what type of a warning is the Trafodion scanner producing?  If it’s
> indicating the product might not run successfully/correctly then I think
> there has been sufficient testing to this point to remove the warning.  All
> software products either contain bugs or new bugs can be introduced with
> any change in software or hardware, including the HT support in Linux, but
> I’m not aware of any existing bug report that would preclude turning HT on
> while using Trafodion on that system.
>
>
>
>   If the warning implies there could be performance considerations
> involved when using HT then I think that will always be a valid concern,
> though maybe it should be more informational than a warning.  Very few
> performance optimizations, of which HT is an example, improve performance
> in every possible case.  Without knowing how the user’s application will
> use the system there’s no way to know if turning HT on will help
> significantly, provide a modest boost in performance, or perhaps be a minor
> detriment to system performance.  One could argue the same for how much
> memory is installed on each node, how many and how the disk drives are
> configured, etc.  So if this is a performance warning then likely it should
> be removed.
>
>
>
> Dennis
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Friday, February 05, 2016 5:22 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Hyperthreading
>
>
>
> I'm noticing a check for hyper threading in the Trafodion scanner but it's
> a warning. What's the concern?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Disable HBase Region Rebalancing

[Gunnar Tapper]

Hi Atanu,

Still confused. balance_switch is a standard HBase feature. Users may or
may not have this feature enabled.

I think that you're saying that Trafodion recommends to turn this feature
off in 1.3.0 but is OK with it being turned on in 2.0.0? Or, is there
another functionality I am missing.

Gunnar

On Wed, Feb 10, 2016 at 4:58 PM, Atanu Mishra  wrote:

> Yes. And yes.
>
> The functionality (to handle active transactions during rebalance/splits)
> was checked-in post-1.3.0. It is disabled currently, but should be enabled
> in time for 2.0.0.
>
> To clarify -
> for 1.3.0, we still need the current recommendation for balance_switch
> for 2.0.0, the recommendation is not needed since the functionality will
> be enabled by default.
>
> In the interim, a user will need to enable the functionality manually.
>
> Regards,
> Atanu
>
> ____
> Atanu Mishra
>
> On Wed, Feb 10, 2016 at 2:26 PM, Gunnar Tapper 
> wrote:
>
>> Is this changed from 1.3.0 to 2.0.0?
>>
>> I'm a bit confused by Atanu's comment and Trina's subsequent response...
>> are we still recommending that balance_switch should be false and only be
>> enabled during maintenance windows?
>>
>> On Wed, Feb 10, 2016 at 3:20 PM, Trina Krug  wrote:
>>
>>> Yes, they will.  Sorry if my answer was misleading.  I was speaking
>>> directly to the document section regarding disabling rebalancing due to
>>> transactions aborting.
>>>
>>> Trina
>>>
>>> On Feb 10, 2016, at 2:00 PM, Atanu Mishra  wrote:
>>>
>>> Wasn't sure - I think the user will need to enable the functionality
>>> first to see this behavior.
>>>
>>> Thanks,
>>> Atanu
>>>
>>> 
>>> Atanu Mishra
>>>
>>> On Wed, Feb 10, 2016 at 1:47 PM, Trina Krug 
>>> wrote:
>>>
>>>> Rebalancing can now be done with active transactions and they *can*
>>>> survive across a rebalance.  There may be times when a transaction is
>>>> aborted after new transactional activity is rejected during the rebalance
>>>> however.  But most often failed operations can be (and will be) retried and
>>>> succeed.
>>>>
>>>> Trina
>>>>
>>>> On Feb 10, 2016, at 1:11 PM, Gunnar Tapper 
>>>> wrote:
>>>>
>>>> Is this information still relevant?
>>>>
>>>>
>>>> https://cwiki.apache.org/confluence/display/TRAFODION/Configuration#Configuration-DisablingHBaseRegionRebalancing
>>>>
>>>>
>>>> --
>>>> Thanks,
>>>>
>>>> Gunnar
>>>> *If you think you can you can, if you think you can't you're right.*
>>>>
>>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Provisioning Guide (draft)

[Gunnar Tapper]

Try: https://drive.google.com/open?id=0BxlwNhWxn8iTU29WM1dPT2JmZ00
<https://drive.google.com/open?id=0BxlwNhWxn8iTU29WM1dPT2JmZ00>


On Wed, Feb 10, 2016 at 3:56 PM, Amanda Moran 
wrote:

> Can you send just the pdf?
>
> The zip file doesn't work for me. When I open the pdf (after extracting..)
> its just blank.
>
> Thanks.
>
> On Wed, Feb 10, 2016 at 2:50 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> I've uploaded a draft version of the Trafodion Provisioning Guide to:
>> https://drive.google.com/open?id=0BxlwNhWxn8iTRXEzTXVUTlphM1E
>>
>>
>> This version deals with prerequisites only explaining what is required to
>> perform the different changes that are necessary to install Trafodion.
>>
>> The upcoming chapters will provide the following information:
>>
>> - Overview of the installation and upgrade process
>> - Trafodion Installer (arguments, config file, etc.)
>> - Installation Preparation (includes installing optional PC tools,
>> information gathering, etc.)
>> - Installation
>> - Activation
>> - Upgrade Preparation
>> - Upgrade
>> - Activation
>> - Manual Install
>> - Manual Upgrade
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion Provisioning Guide (draft)

[Gunnar Tapper]

Hi,

I've uploaded a draft version of the Trafodion Provisioning Guide to:
https://drive.google.com/open?id=0BxlwNhWxn8iTRXEzTXVUTlphM1E


This version deals with prerequisites only explaining what is required to
perform the different changes that are necessary to install Trafodion.

The upcoming chapters will provide the following information:

- Overview of the installation and upgrade process
- Trafodion Installer (arguments, config file, etc.)
- Installation Preparation (includes installing optional PC tools,
information gathering, etc.)
- Installation
- Activation
- Upgrade Preparation
- Upgrade
- Activation
- Manual Install
- Manual Upgrade

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Disable HBase Region Rebalancing

[Gunnar Tapper]

Is this changed from 1.3.0 to 2.0.0?

I'm a bit confused by Atanu's comment and Trina's subsequent response...
are we still recommending that balance_switch should be false and only be
enabled during maintenance windows?

On Wed, Feb 10, 2016 at 3:20 PM, Trina Krug  wrote:

> Yes, they will.  Sorry if my answer was misleading.  I was speaking
> directly to the document section regarding disabling rebalancing due to
> transactions aborting.
>
> Trina
>
> On Feb 10, 2016, at 2:00 PM, Atanu Mishra  wrote:
>
> Wasn't sure - I think the user will need to enable the functionality first
> to see this behavior.
>
> Thanks,
> Atanu
>
> 
> Atanu Mishra
>
> On Wed, Feb 10, 2016 at 1:47 PM, Trina Krug  wrote:
>
>> Rebalancing can now be done with active transactions and they *can*
>> survive across a rebalance.  There may be times when a transaction is
>> aborted after new transactional activity is rejected during the rebalance
>> however.  But most often failed operations can be (and will be) retried and
>> succeed.
>>
>> Trina
>>
>> On Feb 10, 2016, at 1:11 PM, Gunnar Tapper 
>> wrote:
>>
>> Is this information still relevant?
>>
>>
>> https://cwiki.apache.org/confluence/display/TRAFODION/Configuration#Configuration-DisablingHBaseRegionRebalancing
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Disable HBase Region Rebalancing

[Gunnar Tapper]

Is this information still relevant?

https://cwiki.apache.org/confluence/display/TRAFODION/Configuration#Configuration-DisablingHBaseRegionRebalancing


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: traf_*mods in trafodion installation

[Gunnar Tapper]

+1. It sounds to me that the installer should default to an end-user mode
where it installs as little as possible and then have a command-line
argument for developer mode installing whatever is needed for debugging?

Thanks,

Gunnar

On Wed, Feb 10, 2016 at 11:05 AM, Amanda Moran 
wrote:

> THANK YOU MING! And during your holidays too!!! Gung hay fat choy!
>
> Really appreciate the explanation ( I am sure Gunnar does too!).
>
>
> On Wed, Feb 10, 2016 at 5:07 AM, Liu, Ming (Ming) 
> wrote:
>
>> Hi, all,
>>
>>
>>
>> Very glad we are discussing this. Although I think this is more suitable
>> for the dev mail list J
>>
>>
>>
>> First reply to Amanda’s question ,
>>
>> “hbase-site hbase.regionserver.region.transactional.tlog true “ is no
>> longer need, you can remove it from traf_*modes for sure.
>>
>> I also strongly think “hbase-site hbase.bulkload.staging.dir
>> /hbase-staging” is no longer required, but I cannot make 100% sure of it.
>> Bulkloader expert should confirm it. The only reference seems like a dead
>> code for me, HBulkLoadClient.java line 96.
>>
>>
>>
>> And, I have started a similar discussion for some other traf_*mods
>> changes at Jira 1729/1730..
>>
>> With TRAFODION-1729, there is no need for the Trafodion installer to
>> change this specific hbase-site.xml setting : “hbase-site
>> hbase.coprocessor.region.classes”.
>>
>> But we leave it there in installer, since there are still needs to have
>> hbase-site.xml changed for some developers to easily change them for debug
>> purpose. But I really think no end user ever need to understand it or even
>> config it. And, there are still some serious concerns about this JIRA, so
>> we keep current behavior unchanged until all people are confident about
>> this change. J ( In fact, there is already a problem reported and solved
>> by Dave due to this checkin…, but it is a minor issue comparing the problem
>> it aims to solve), But technically, this item can now be removed from
>> traf_*mod change list, Trafodion is smart enough now to add required
>> coprocessor on the fly , if hbase-site.xml doesn’t have these settings.
>>
>> With TRAFODION-1730, which in fact solved by HBase community
>> (HBASE-15076), it is also possible the installer no longer need to change
>> the “hbase-site hbase.hregion.impl” settings soon. However, That HBase
>> change is merged into HBase R1.2, so until Trafodion can support HBase
>> R1.2, installer still need to change this setting item. And Trafodion DTM
>> code need some change for this as well, which not done yet. For Gunnar’s
>> documentation purpose, i.e. why Trafodion needs to change this item? I have
>> a lengthy explanation at HBASE-15076, don’t want to paste that long text
>> here. https://issues.apache.org/jira/browse/HBASE-15076?filter=-2
>>
>>
>>
>> So sorry that although we are working on these two jiras, installer must
>> still take care of them for now… And as Amanda listed, there are still more
>> items unknown than known, so I really hope more people can join this
>> discussion and we can finally remove all of them if possible, at least
>> minimize the list.
>>
>>
>>
>> Although a long reply, the only item I came out for sure now is one can
>> remove the “hbase.regionserver.region.transactional.tlog” from traf_*mod
>> scripts...
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人:* Amanda Moran [mailto:amanda.mo...@esgyn.com]
>> *发送时间:* 2016年2月10日 1:43
>> *收件人:* user@trafodion.incubator.apache.org
>> *主题:* Re: traf_*mods in trafodion installation
>>
>>
>>
>> Amanda: it should be possible and desireable to make all these
>> configuration changes in advance. They're totally valid HBase configuration
>> settings that could very-well exist in advance.
>>
>>
>>
>> [Amanda]: I would like to know the smallest number of these that must be
>> set in order for Trafodion to be installer. Are all these settings
>> mandatory for installation/start? This is what I want/need to know. Does a
>> user have to go and set all those settings by hand in advance of
>> installation Trafodion (assuming we 'remove' the traf_*mods scripts)?
>>
>>
>>
>>
>>
>> On Tue, Feb 9, 2016 at 9:32 AM, Gunnar Tapper 
>> wrote:
>>
>> Amanda: it should be possible and desireable to make all these
>> configuration changes in advance. They're totally valid HBase configuration
>> settings that could very-well exist in

Re: traf_*mods in trafodion installation

[Gunnar Tapper]

Amanda: it should be possible and desireable to make all these
configuration changes in advance. They're totally valid HBase configuration
settings that could very-well exist in advance.

The worse situation is if the Trafodion settings clash with some setting
that the customer already has for some other reason. For example, can we
really change the staging setting without affecting something else? This is
why I am documenting these settings as requirements in the upcoming
Provisioning Guide with the reasoning behind the setting.

Further, I really recommend that we separate Trafodion installation from
configuration changes in the infrastructure to ensure that it's possible to
change the configuration changes, test their impact, and THEN install
Trafodion. The testing could consist of something as simple as verify the
restart worked or as advanced as an application regression test. Very user
specific and dependent what else HDFS and HBase is being used for. For
example, what's the impact on the rest of the Hadoop environment if turning
on HDFS ACLs?

Thanks,

Gunnar

Gunnar

On Tue, Feb 9, 2016 at 9:45 AM, Amanda Moran  wrote:

> I agree with that :) Thanks Qifan!
>
> On Tue, Feb 9, 2016 at 8:43 AM, Qifan Chen  wrote:
>
>> Hi Amanda,
>>
>> I know the topic that I brought up is a little bit different :-).
>>
>> But the objectives of both thoughts are pretty much in line with the
>> improvement of install experiences.
>>
>> Thank you.
>>
>> --Qifan
>>
>> On Tue, Feb 9, 2016 at 10:36 AM, Amanda Moran 
>> wrote:
>>
>>> Thanks for the response Qifan... but I am not sure we are talking about
>>> the same thing.
>>>
>>> I am talking about the traf__mods98 script that is run as
>>> apart of the Trafodion Installation scripts. It is used to setup HBase
>>> settings, copy hbase-trx*.jar file, and restart HBase, HDFS, and Zookeeper.
>>>
>>> I would like to know what are the smallest number of settings that need
>>> to be set in advance for Trafodion to install/start.
>>>
>>> Examples of things set:
>>> hbase-site hbase.master.distributed.log.splitting false
>>>
>>> hbase-site hbase.coprocessor.region.classes
>>> "org.apache.hadoop.hbase.coprocessor.transactional.TrxRegionObserver,org.apache.hadoop.hbase.coprocessor.transactional.TrxRegionEndpoint,org.apache.hadoop.hbase.coprocessor.AggregateImplementation"
>>>
>>> hbase-site hbase.hregion.impl
>>> org.apache.hadoop.hbase.regionserver.transactional.TransactionalRegion
>>>
>>> hbase-site hbase.regionserver.region.split.policy
>>> org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy
>>>
>>> hbase-site hbase.snapshot.enabled true
>>>
>>> hbase-site hbase.bulkload.staging.dir /hbase-staging
>>>
>>> hbase-site hbase.regionserver.region.transactional.tlog true
>>>
>>> hbase-site hbase.snapshot.master.timeoutMillis 60
>>>
>>> hbase-site hbase.snapshot.region.timeout 60
>>>
>>> hdfs-site dfs.namenode.acls.enabled true
>>>
>>> hbase-site hbase.client.scanner.timeout.period 60
>>>
>>> Thanks all!
>>>
>>> On Thu, Feb 4, 2016 at 5:40 AM, Qifan Chen  wrote:
>>>
 Hi Amanda,

 I like your idea.

 On Trafodion's modification of config files for HBase, HDFS, and
 Zookeeper, I wonder if it is possible to re-difine the port range for an
 install, without going through all the install steps. This has the
 practical value that due to port conflict, an install could not start
 successfully, and one can easily switch to a different port range to retry
 with this capability.

 In addition, some of the install steps, such as TPCDS data set
 generation, and conversion to UTF8, could be made parallel to shorten the
 install duration. They are done one table at a time in serial mode now.

 TPCDS table data is generated through the command "dsdgen -scale ..."
 which could take the option "-parallel".
 Data conversion to UTF8 is done through the iconv utility.

 Regards, --Qifan







 On Wed, Feb 3, 2016 at 10:34 PM, Amanda Moran 
 wrote:

> HI there All-
>
> The traf_*_mods scripts are used during installation to set HBase,
> HDFS, and Zookeeper settings needed by Trafodion.
>
> The script takes a long time to run (slowing down installation by a
> lot) because it needs to restart all these services for the changes to be
> picked up.
>
> My question is: What if I wanted to set the settings in advance of
> running the installer. What would be the absolute minimum set of settings
> that I need to get installed? I could set other settings later with a
> script or by hand.
>
> Thanks!
> --
> Thanks,
>
> Amanda Moran
>



 --
 Regards, --Qifan


>>>
>>>
>>> --
>>> Thanks,
>>>
>>> Amanda Moran
>>>
>>
>>
>>
>> --
>> Regards, --Qifan
>>
>>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't y

Re: Trafodion environment changes

[Gunnar Tapper]

Also, how relevant is this page:
https://cwiki.apache.org/confluence/display/TRAFODION/Configuration

It does not match what I find in the 1.3 installer.

On Mon, Feb 8, 2016 at 2:37 PM, Gunnar Tapper 
wrote:

> Hi,
>
> I'm trying to understand the purpose of the different environmental
> changes that are required during Trafodion install to help administrators
> understand what needs to happen when installing Trafodion onto their
> Hadoop/HDFS/HBase environment. Think "what's the purpose of this
> configuration change", "what it this directory/file/jar/etc used for", and
> so on
>
> ZOOKEEPER
>
>- zoo.cfg: Change maxClientCnxns to 0.
>
> HDFS
>
>- Create /hbase-staging, change owner to HBase Administrator.
>- Create /bulkload, change owner to Trafodion.
>- Create /apps/hbase/data/archive, change owner to hbase:hbase
>(Cloudera) or hbase:hdfs (Hortonworks), give the trafodion RWX access, set
>default user to trafodion, and setaflc to RWX.
>
> HBASE
>
>- Install Trafodion utility jar into /usr/lib/hbase/lib (and other
>directories): what functions does this jar provide?
>- hbase-site.xml: Change hbase.coprocessor.region.classes to a list of
>classes. (It'd be good give a short description of each class.)
>- hbase-site.xml: Change hbase.hregion.impl to org.apache.hadoop.
>hbase.regionserver.transactional.TransactionalRegion
>- hbase-site.xml: Change hbase.regionserver.region.split.policy to
>org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy
>
> --
> Thanks,
>
> Gunnar
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion environment changes

[Gunnar Tapper]

Hi,

I'm trying to understand the purpose of the different environmental changes
that are required during Trafodion install to help administrators
understand what needs to happen when installing Trafodion onto their
Hadoop/HDFS/HBase environment. Think "what's the purpose of this
configuration change", "what it this directory/file/jar/etc used for", and
so on

ZOOKEEPER

   - zoo.cfg: Change maxClientCnxns to 0.

HDFS

   - Create /hbase-staging, change owner to HBase Administrator.
   - Create /bulkload, change owner to Trafodion.
   - Create /apps/hbase/data/archive, change owner to hbase:hbase
   (Cloudera) or hbase:hdfs (Hortonworks), give the trafodion RWX access, set
   default user to trafodion, and setaflc to RWX.

HBASE

   - Install Trafodion utility jar into /usr/lib/hbase/lib (and other
   directories): what functions does this jar provide?
   - hbase-site.xml: Change hbase.coprocessor.region.classes to a list of
   classes. (It'd be good give a short description of each class.)
   - hbase-site.xml: Change hbase.hregion.impl to org.apache.hadoop.
   hbase.regionserver.transactional.TransactionalRegion
   - hbase-site.xml: Change hbase.regionserver.region.split.policy to
   org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Hyperthreading

[Gunnar Tapper]

I'm noticing a check for hyper threading in the Trafodion scanner but it's
a warning. What's the concern?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion Runtime Security

[Gunnar Tapper]

Hi,

I'm trying to document introductory-level security requirements for
Trafodion, both runtime and during provisining
(installation/upgrade/resizing/removal).

This is what I have for runtime:

The `trafodion:trafodion` user ID is created as part of the installation
process. Trafodion runs under this ID, which must be
registered as a user in the Hadoop Distributed File System (HDFS) to store
and access objects in HDFS, HBase, and Hive.
In addition, the `trafodion` user ID required passwordless access among the
nodes where Trafodion is installed to run cross-node Trafodion functions
such as scripts.

Trafodion requires that either HDFS ACLs or Kerberos is enabled.

Trafodion users are managed by the Trafodion SQL security features (grant,
revoke, etc.), which can be integrated with LDAP if so desired.
These users are referred to as *database users* and do not have direct
access to the operating system.


What did I miss? What did I get wrong?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Release 2.0 Hadoop/HBase Versions?

[Gunnar Tapper]

"tested with, should support other versions"

On Fri, Feb 5, 2016 at 11:56 AM, Steve Varnau 
wrote:

> Sure, we can collect this info in the release notes. I think, however,
> that we need to differentiate the direct dependencies, particularly the
> components that Trafodion is tightly integrated with (i.e., HBase, and to
> lesser degree HDFS, Hive) versus things that are generally can interoperate
> with (e.g., Sqoop) and the version is less likely to be an issue.
>
>
>
> --Steve
>
>
>
> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com]
> *Sent:* Friday, February 5, 2016 9:00 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Trafodion Release 2.0 Hadoop/HBase Versions?
>
>
>
> Hi,
>
>
>
> I agree - as folks develop and test Trafodion, we should note the versions
> of all Hadoop ecosystem components that we test with (whether from a vendor
> Hadoop distro or as part of setting up an Apache Hadoop cluster to test
> on).
>
>
>
> Steve, as release manager... As part of the release notes, can we
> collect/include this information? Some of it was in the R1.3 release notes,
> but with Apache Hadoop support we really need to document more, as Gunnar
> notes. I can volunteer to organize it into a table, or Gunnar might want to
> since he's done an incredible job pulling together the web site and other
> documentation.
>
>
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
> On Thu, Feb 4, 2016 at 11:09 PM, Gunnar Tapper 
> wrote:
>
> Hi,
>
>
>
> Apache Hadoop covers HDFS, MapReduce, and YARN only. Therefore, I think we
> need to also document what version of HBase, Hive, Sqoop, etc. we've tested
> for a vanilla Hadoop environments. Or not tested as the case may be; for
> example, "Sqoop version X tested with CDH and HDP but not explicitly tested
> with vanilla Hadoop."
>
>
>
> Gunnar
>
>
>
> On Thu, Feb 4, 2016 at 5:52 PM, Carol Pearson 
> wrote:
>
> Hi Trafodion Fans,
>
>
>
> I'm trying to make sure I'm clear on the targeted runtime environments for
> our next release, which I think we're calling Trafodion 2.0.  I've seen
> that it needs to  support working with Apache Hadoop, since the 1.3 release
> supported only the  Cloudera and Hadoop distros.
>
>
>
> *Trafodion 2.0*
>
>
>
> From what's been discussed on the Dev list and here, I think the target is:
>
>
>
>  - Linux Versions CentOS 6.5-6.7 (RHEL 6.5-6.7 - untested? but should
> support)
>
>  - SUSE?
>
>
>
>  Hadoop/VersionHBase Version
>
> =
>
> Cloudera CDH 5.4.x 1.1
>
> Hortonworks HDP 2.31.1
>
> Apache Hadoop 2.7.11.1
>
>
>
>
>
> Are these the targets that folks are working on Trafodion 2.0 to support?
> Are they the right ones? (For example, should we be looking at Apache
> Hadoop 2.6.3?)
>
>
>
> Are there other versions of software in the Hadoop ecosystem whose
> versions should be specified as targets, especially for distro-less vanilla
> Apache Hadoop?
>
>
>
> I think that once we release, we should identify the specific versions
> that folks have tested with (which might not be all versions and all
> distros).  I think we should also list versions for software that we
> believe should work but have not been tested. As I was trying to understand
> which releases worked with what, I came across a great chart in the the
> HBase reference book in section 4.1:
> https://hbase.apache.org/book.html#basic.prerequisites then scroll down
> to see the Hadoop versions.  It would be great to develop that chart for
> Trafodion as 2.0 goes forward.
>
>
>
> Thanks for any light people can shed on this!
>
> -Carol P.
>
>
>
> PS:  For reference, here's my understanding of what Trafodion 1.3
> supported:
>
> I've put together the following chart based on the notes from the
> Trafodion website for release 1.3 and my understanding of Trafodion 2.0:
>
>
>
> *Trafodion 1.3: (Current release)*
>
>
>
>   - Linux Versions:  CentOS 6.5-6.7, (RHEL 6.5-6.7 - untested? but should
> support)
>
>
>
>  Hadoop/VersionHBase Version
>
> =
>
> Cloudera CDH 5.3.x 0.98
>
> Hortonworks HDP 2.20.98
>
>
>
>
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Release 2.0 Hadoop/HBase Versions?

[Gunnar Tapper]

+1

The Trafodion project needs to do everything it can to make it easy for
users to adopt the great software. Is there any special work that needs to
be done beyond maintaining the installer and running tests?

Thanks,

Gunnar

On Fri, Feb 5, 2016 at 9:56 AM, Carol Pearson 
wrote:

> Hi Atanu,
>
> Thanks!  I think that we need to make it as easy as possible for our users
> to try Trafodion and to use Trafodion.  I don't think most of our
> non-developer users will be using Trafodion on a plain Apache platform,
> especially if they're trying it in a commercial environment.  Hortonworks
> and Cloudera have free community editions.
>
> As we're trying to increase our user base and grow our community, it seems
> to me that we want to make it easier for folks to try and to use Trafodion,
> rather than harder.  So making sure we have basic functionality that works
> on the most common distros seems to me to be a basic requirement for
> success.
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Thu, Feb 4, 2016 at 11:25 PM, Atanu Mishra 
> wrote:
>
>> Hi Carol,
>>
>> Great question! Once Trafodion supports Apache Hadoop/HBase, I question
>> whether there is a reason to continue to support the Cloudera and
>> HortonWorks distros.
>>
>> Thanks,
>> Atanu
>>
>> -
>>
>> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com]
>> *Sent:* Thursday, February 4, 2016 4:53 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Trafodion Release 2.0 Hadoop/HBase Versions?
>>
>>
>>
>> Hi Trafodion Fans,
>>
>>
>>
>> I'm trying to make sure I'm clear on the targeted runtime environments
>> for our next release, which I think we're calling Trafodion 2.0.  I've seen
>> that it needs to  support working with Apache Hadoop, since the 1.3 release
>> supported only the  Cloudera and Hadoop distros.
>>
>>
>>
>> *Trafodion 2.0*
>>
>>
>>
>> From what's been discussed on the Dev list and here, I think the target
>> is:
>>
>>
>>
>>  - Linux Versions CentOS 6.5-6.7 (RHEL 6.5-6.7 - untested? but should
>> support)
>>
>>  - SUSE?
>>
>>
>>
>>  Hadoop/VersionHBase Version
>>
>> =
>>
>> Cloudera CDH 5.4.x 1.1
>>
>> Hortonworks HDP 2.31.1
>>
>> Apache Hadoop 2.7.11.1
>>
>>
>>
>>
>>
>> Are these the targets that folks are working on Trafodion 2.0 to
>> support?  Are they the right ones? (For example, should we be looking at
>> Apache Hadoop 2.6.3?)
>>
>>
>>
>> Are there other versions of software in the Hadoop ecosystem whose
>> versions should be specified as targets, especially for distro-less vanilla
>> Apache Hadoop?
>>
>>
>>
>> I think that once we release, we should identify the specific versions
>> that folks have tested with (which might not be all versions and all
>> distros).  I think we should also list versions for software that we
>> believe should work but have not been tested. As I was trying to understand
>> which releases worked with what, I came across a great chart in the the
>> HBase reference book in section 4.1:
>> https://hbase.apache.org/book.html#basic.prerequisites then scroll down
>> to see the Hadoop versions.  It would be great to develop that chart for
>> Trafodion as 2.0 goes forward.
>>
>>
>>
>> Thanks for any light people can shed on this!
>>
>> -Carol P.
>>
>>
>>
>> PS:  For reference, here's my understanding of what Trafodion 1.3
>> supported:
>>
>> I've put together the following chart based on the notes from the
>> Trafodion website for release 1.3 and my understanding of Trafodion 2.0:
>>
>>
>>
>> *Trafodion 1.3: (Current release)*
>>
>>
>>
>>   - Linux Versions:  CentOS 6.5-6.7, (RHEL 6.5-6.7 - untested? but should
>> support)
>>
>>
>>
>>  Hadoop/VersionHBase Version
>>
>> =
>>
>> Cloudera CDH 5.3.x 0.98
>>
>> Hortonworks HDP 2.20.98
>>
>>
>>
>>
>>
>>
>> ---
>>
>> Email:carol.pearson...@gmail.com
>>
>> Twitter:  @CarolP222
>>
>> ---
>> 
>> Atanu Mishra
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion sandbox download

[Gunnar Tapper]

The sandbox isn't available due to license issues with the Cloudera
distribution that was used. However, you can Trafodion on Amazon instead:
https://aws.amazon.com/marketplace/pp/B018RBMFG0

Thanks,

Gunnar

On Fri, Feb 5, 2016 at 7:40 AM, Liu Ming  wrote:

> hi, all,
>
>
> I remember there is a place to download Trafodion sandbox, but I cannot
> find it now. Is that still avaiable?
>
>
> thanks,
>
> Ming
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion Release 2.0 Hadoop/HBase Versions?

[Gunnar Tapper]

Hi,

Apache Hadoop covers HDFS, MapReduce, and YARN only. Therefore, I think we
need to also document what version of HBase, Hive, Sqoop, etc. we've tested
for a vanilla Hadoop environments. Or not tested as the case may be; for
example, "Sqoop version X tested with CDH and HDP but not explicitly tested
with vanilla Hadoop."

Gunnar

On Thu, Feb 4, 2016 at 5:52 PM, Carol Pearson 
wrote:

> Hi Trafodion Fans,
>
> I'm trying to make sure I'm clear on the targeted runtime environments for
> our next release, which I think we're calling Trafodion 2.0.  I've seen
> that it needs to  support working with Apache Hadoop, since the 1.3 release
> supported only the  Cloudera and Hadoop distros.
>
> *Trafodion 2.0*
>
> From what's been discussed on the Dev list and here, I think the target is:
>
>  - Linux Versions CentOS 6.5-6.7 (RHEL 6.5-6.7 - untested? but should
> support)
>  - SUSE?
>
>  Hadoop/VersionHBase Version
> =
> Cloudera CDH 5.4.x 1.1
> Hortonworks HDP 2.31.1
> Apache Hadoop 2.7.11.1
>
>
> Are these the targets that folks are working on Trafodion 2.0 to support?
> Are they the right ones? (For example, should we be looking at Apache
> Hadoop 2.6.3?)
>
> Are there other versions of software in the Hadoop ecosystem whose
> versions should be specified as targets, especially for distro-less vanilla
> Apache Hadoop?
>
> I think that once we release, we should identify the specific versions
> that folks have tested with (which might not be all versions and all
> distros).  I think we should also list versions for software that we
> believe should work but have not been tested. As I was trying to understand
> which releases worked with what, I came across a great chart in the the
> HBase reference book in section 4.1:
> https://hbase.apache.org/book.html#basic.prerequisites then scroll down
> to see the Hadoop versions.  It would be great to develop that chart for
> Trafodion as 2.0 goes forward.
>
> Thanks for any light people can shed on this!
> -Carol P.
>
> PS:  For reference, here's my understanding of what Trafodion 1.3
> supported:
> I've put together the following chart based on the notes from the
> Trafodion website for release 1.3 and my understanding of Trafodion 2.0:
>
> *Trafodion 1.3: (Current release)*
>
>   - Linux Versions:  CentOS 6.5-6.7, (RHEL 6.5-6.7 - untested? but should
> support)
>
>  Hadoop/VersionHBase Version
> =
> Cloudera CDH 5.3.x 0.98
> Hortonworks HDP 2.20.98
>
>
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: HDFS ACLs dependency

[Gunnar Tapper]

Well yes, if you enable ACLs then you have to create the ACLs, too. :)

Perhaps the issue here is that Trafodion can't get access to
/hbase/archives w/o ACLs since that directory may be owned by another user
in a group other than trafodion?

I'm mostly trying to document requirements and reasoning for things like
this to provide "comfort" when doing installation: "during installation,
Trafodion will make these changes to your environment for these reasons" is
a lot better than "hey, what happened to my environment? HDFS ACLs are
enabled!"

Thanks,

Gunnar

On Thu, Feb 4, 2016 at 3:31 PM, Amanda Moran  wrote:

> # NOTE: These command must be done AFTER acls are
> #   enabled and HDFS has been restarted
> echo "***INFO: Setting HDFS ACLs for snapshot scan support"
> sudo su hdfs --command "$HADOOP_BIN_PATH/hdfs dfs -mkdir -p /hbase/archive"
> if [ $? != 0 ]; then
>echo "***ERROR: ($HADOOP_BIN_PATH/hdfs dfs -mkdir -p /hbase/archive)
> command failed"
>exit -1
> fi
> sudo su hdfs --command "$HADOOP_BIN_PATH/hdfs dfs -chown hbase:hbase
> /hbase/archive"
> if [ $? != 0 ]; then
>echo "***ERROR: ($HADOOP_BIN_PATH/hdfs dfs -chown hbase:hbase
> /hbase/archive) command failed"
>exit -1
> fi
> sudo su hdfs --command "$HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m
> user:$TRAF_USER:rwx /hbase/archive"
> if [ $? != 0 ]; then
>echo "***ERROR: ($HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m
> user:$TRAF_USER:rwx /hbase/archive) command failed"
>exit -1
> fi
> sudo su hdfs --command "$HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m
> default:user:$TRAF_USER:rwx /hbase/archive"
> if [ $? != 0 ]; then
>echo "***ERROR: ($HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m
> default:user:$TRAF_USER:rwx /hbase/archive) command failed"
>exit -1
> fi
> sudo su hdfs --command "$HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m mask::rwx
> /hbase/archive"
> if [ $? != 0 ]; then
>echo "***ERROR: ($HADOOP_BIN_PATH/hdfs dfs -setfacl -R -m mask::rwx
> /hbase/archive) command failed"
>exit -1
> fi
>
>
> Here is the code that needs ACLS to be set to true. Maybe this helps ... :)
>
> On Thu, Feb 4, 2016 at 2:26 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> I noticed that Trafodion requires that dfs.namenode.acls.enabled is set
>> to true. The reason for this seems to be a desire to do a set setfacl on
>> hbase/archive.
>>
>> Is this a true requirement or an embedded best practices?
>>
>> I'm wondering since we're now imposing security policies on the user even
>> if the user has chosen to rely on the traditional POSIX permission model
>> over implementing the extended POSIX ACL model. Also, how does this HDFS
>> configuration flag relate to a user that is using Kerberos?
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

HDFS ACLs dependency

[Gunnar Tapper]

Hi,

I noticed that Trafodion requires that dfs.namenode.acls.enabled is set to
true. The reason for this seems to be a desire to do a set setfacl on
hbase/archive.

Is this a true requirement or an embedded best practices?

I'm wondering since we're now imposing security policies on the user even
if the user has chosen to rely on the traditional POSIX permission model
over implementing the extended POSIX ACL model. Also, how does this HDFS
configuration flag relate to a user that is using Kerberos?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion user security

[Gunnar Tapper]

Thanks. I will add the Kerberos installation procedure to the
installation-preparation activities.

I hope someone can comment on the questions related to manipulation of the
Hadoop environment?

Thanks,

Gunnar

On Wed, Feb 3, 2016 at 4:30 PM, Roberta Marton 
wrote:

> The Kerberos installation procedure sets up security attributes as
> required.
>
>
>
> Roberta
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, February 3, 2016 3:28 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Trafodion user security
>
>
>
> OK. So this is a prerequisite for install, right? Any need for similar
> configuration at the HDFS level? The installer does a bunch of things to
> HDFS directly.
>
>
>
> Some other questions related to installation:
>
>
>
> 1. I assume that Trafodion is the only project using HBase-TRX and,
> therefore, it's OK to overwrite $HADOOP_PATH/hbase-trx*?
>
> 2. Is Trafodion the only project using /hbase-staging, /bulkload, and
> /lobs? The installer seems to assume that those directories do not exist.
> Perhaps they get created under the Trafodion user's root directory rather
> than the actual root directory?
>
>
>
> Overall, I am trying to understand and document what happens to the user's
> Hadoop environment when the Trafodion Installer runs so that there are no
> surprises after the installer has made changes to the environment and
> restarted HBase, Zookeeper, and HDFS.
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Wed, Feb 3, 2016 at 4:05 PM, Roberta Marton 
> wrote:
>
> If you are not running with security enabled (aka Kerberos), then no
> privilege checking is performed so you should not have to add the Trafodion
> ID.
>
> If you are running with Kerberos enabled, then you need to give the
> trafodion ID necessary privileges in HBase and HDFS.  This, of course,
> requires a Trafodion principal defined in Kerberos.
>
>
>
> For example, in HBase, after creating and setting up your Kerberos ID, you
> grant trafodion privileges:
>
>
>
> $ sudo -u hbase hbase shell
>
> grant 'trafodion', 'RWXCA'
>
> exit
>
>
>
>Roberta
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, February 3, 2016 2:19 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion user security
>
>
>
> Hi,
>
>
>
> From what I understand, Trafodion runs under its own user ID and group,
> which needs sudo access to the ip and arping Linux utilities.
>
>
>
> However, it's not clear to me if this user ID need to be added to HDFS and
> HBase, too?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: Trafodion's usage of Except

[Gunnar Tapper]

Hi Ming,

I am working on the Provisioning Guide for 1.3. You can update the
Contributor Guide to your heart's content and should do so as part of your
change. :)

Thanks,

Gunnar

On Wed, Feb 3, 2016 at 4:20 PM, Liu, Ming (Ming)  wrote:

> Hi, Gunnar,
>
>
>
> I am working on TRAFODION-1750, which will remove the dependencies of
> qpid, it will further reduce the list of packages to install,specificly, it
> will remove these packages:
>
>
>
> python-qpid \
>
>  python-qpid-qmf qpid-cpp-client \
>
>  qpid-cpp-client-ssl qpid-cpp-server qpid-cpp-server-ssl \
>
>  qpid-qmf qpid-tools
>
>
>
> Once it is done, you can further shorten the yum install list in the wiki
> page
> https://cwiki.apache.org/confluence/display/TRAFODION/Create+Build+Environment
> for the “Install Required Packages” section.
>
> Very glad you are working on this, to minimize this list is very important.
>
>
>
> Another proposal from me is about libhdfs.so, the default built libhdfs.so
> from Apache Hadoop tar is 32 bit. I think the CDH tar also cannot be used
> directly. Build from HDFS source is not very straight forward.
>
> So it will be good to have a github repository or other public places to
> put a copy of it, so everyone can download directly. Since Trafodion is not
> a good place to put in binary package.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *发送时间:* 2016年2月4日 2:02
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: Trafodion's usage of Except
>
>
>
> Hi,
>
>
>
> You're right.
>
>package_list="log4cxx sqlite expect perl-DBD-SQLite* protobuf xerces-c
> perl-Params-Validate perl-Time-HiRes gzip"
>
>
>
> I'm trying to determine what's the minimum list of packages that need to
> be installed for; for example, a SUSE deployment. The fewer packages
> required for the end-user environment the better.
>
>
>
> Judging from
> https://cwiki.apache.org/confluence/display/TRAFODION/Create+Build+Environment,
> perl-expect is needed for the build environment but not expect. Thus, I
> wonder if expect isn't needed at all?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Wed, Feb 3, 2016 at 10:53 AM, Steve Varnau 
> wrote:
>
> I don’t think there is an “except” package. Do you mean “expect”?
>
>
>
> I believe expect is used only in the developer test environment, not for
> runtime usage of Trafodion.
>
>
>
> --Steve
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, February 3, 2016 8:51 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion's usage of Except
>
>
>
> Hi,
>
>
>
> I'm trying to understand Trafodion required packages and their usage.
>
>
>
> What's the Except package used for?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion user security

[Gunnar Tapper]

OK. So this is a prerequisite for install, right? Any need for similar
configuration at the HDFS level? The installer does a bunch of things to
HDFS directly.

Some other questions related to installation:

1. I assume that Trafodion is the only project using HBase-TRX and,
therefore, it's OK to overwrite $HADOOP_PATH/hbase-trx*?
2. Is Trafodion the only project using /hbase-staging, /bulkload, and
/lobs? The installer seems to assume that those directories do not exist.
Perhaps they get created under the Trafodion user's root directory rather
than the actual root directory?

Overall, I am trying to understand and document what happens to the user's
Hadoop environment when the Trafodion Installer runs so that there are no
surprises after the installer has made changes to the environment and
restarted HBase, Zookeeper, and HDFS.

Thanks,

Gunnar

On Wed, Feb 3, 2016 at 4:05 PM, Roberta Marton 
wrote:

> If you are not running with security enabled (aka Kerberos), then no
> privilege checking is performed so you should not have to add the Trafodion
> ID.
>
> If you are running with Kerberos enabled, then you need to give the
> trafodion ID necessary privileges in HBase and HDFS.  This, of course,
> requires a Trafodion principal defined in Kerberos.
>
>
>
> For example, in HBase, after creating and setting up your Kerberos ID, you
> grant trafodion privileges:
>
>
>
> $ sudo -u hbase hbase shell
>
> grant 'trafodion', 'RWXCA'
>
> exit
>
>
>
>Roberta
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, February 3, 2016 2:19 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion user security
>
>
>
> Hi,
>
>
>
> From what I understand, Trafodion runs under its own user ID and group,
> which needs sudo access to the ip and arping Linux utilities.
>
>
>
> However, it's not clear to me if this user ID need to be added to HDFS and
> HBase, too?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion user security

[Gunnar Tapper]

Hi,

>From what I understand, Trafodion runs under its own user ID and group,
which needs sudo access to the ip and arping Linux utilities.

However, it's not clear to me if this user ID need to be added to HDFS and
HBase, too?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion's usage of Except

[Gunnar Tapper]

Hi,

You're right.

   package_list="log4cxx sqlite expect perl-DBD-SQLite* protobuf xerces-c
perl-Params-Validate perl-Time-HiRes gzip"

I'm trying to determine what's the minimum list of packages that need to be
installed for; for example, a SUSE deployment. The fewer packages required
for the end-user environment the better.

Judging from
https://cwiki.apache.org/confluence/display/TRAFODION/Create+Build+Environment,
perl-expect is needed for the build environment but not expect. Thus, I
wonder if expect isn't needed at all?

Thanks,

Gunnar

On Wed, Feb 3, 2016 at 10:53 AM, Steve Varnau 
wrote:

> I don’t think there is an “except” package. Do you mean “expect”?
>
>
>
> I believe expect is used only in the developer test environment, not for
> runtime usage of Trafodion.
>
>
>
> --Steve
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gun...@gmail.com]
> *Sent:* Wednesday, February 3, 2016 8:51 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Trafodion's usage of Except
>
>
>
> Hi,
>
>
>
> I'm trying to understand Trafodion required packages and their usage.
>
>
>
> What's the Except package used for?
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion 1.3 and Hortonworks

[Gunnar Tapper]

Thanks Steve!

On Wed, Feb 3, 2016 at 10:33 AM, Amanda Moran 
wrote:

> +1 to Steve.
>
> Thanks.
>
> On Wed, Feb 3, 2016 at 9:31 AM, Steve Varnau 
> wrote:
>
>> The daily test automation has been running on both HDP and CDH distros
>> for a long time.  That is only one aspect of the QA testing, but Trafodion
>> has been developed, regression tested, and supported on both distros.
>>
>>
>>
>> --Steve
>>
>>
>>
>> *From:* Jin, Jian (Seth) [mailto:jian@esgyn.cn]
>> *Sent:* Tuesday, February 2, 2016 6:52 PM
>>
>> *To:* user@trafodion.incubator.apache.org; Ma, Sheng-Chen (Aven) <
>> shengchen...@esgyn.cn>
>> *Subject:* RE: Trafodion 1.3 and Hortonworks
>>
>>
>>
>> Just got Aven comment: we didn’t test on HDP previously. Now it comes
>> question, do we need to support it?
>>
>> If yes, we need to plan to thoroughly  test on HDP and make it work.
>>
>>
>>
>> Br,
>>
>>
>>
>> Seth
>>
>>
>>
>> *From:* Jin, Jian (Seth) [mailto:jian@esgyn.cn ]
>> *Sent:* 2016年2月3日 10:37
>> *To:* user@trafodion.incubator.apache.org; Ma, Sheng-Chen (Aven) <
>> shengchen...@esgyn.cn>
>> *Subject:* RE: Trafodion 1.3 and Hortonworks
>>
>>
>>
>> Hi all,
>>
>>
>>
>> Do we support HDP for Trafodion 1.3? My understanding shall be only
>> vanilla Hbase and CDH Hbase 0.98.10.
>>
>> Aven worked for this we may need get his comment.
>>
>>
>>
>> Br,
>>
>>
>>
>> Seth
>>
>>
>>
>> *From:* Amanda Moran [mailto:amanda.mo...@esgyn.com
>> ]
>> *Sent:* 2016年2月3日 5:07
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: Trafodion 1.3 and Hortonworks
>>
>>
>>
>> HDP 2.2
>>
>>
>>
>> On Tue, Feb 2, 2016 at 1:06 PM, Gunnar Tapper 
>> wrote:
>>
>> Hi Amanda,
>>
>>
>>
>> Thanks for the CDH clarification.
>>
>>
>>
>> What about HDP?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Feb 2, 2016 at 2:05 PM, Amanda Moran 
>> wrote:
>>
>> Trafodion support CDH 5.2 and 5.3 both on HBase 0.98.
>>
>>
>>
>> On Tue, Feb 2, 2016 at 1:04 PM, Gunnar Tapper 
>> wrote:
>>
>> Hi,
>>
>>
>>
>> It's my understanding that Trafodion supports both CDH 5.4.4 and CDH
>> 5.4.5 and, therefore, HBase 1.0.
>>
>>
>>
>> What about HDP 2.2? It uses HBase 0.98.4.
>>
>>
>>
>> *working on the 1.3 Provisioning Guide*
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Amanda Moran
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Amanda Moran
>>
>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion's usage of Except

[Gunnar Tapper]

Hi,

I'm trying to understand Trafodion required packages and their usage.

What's the Except package used for?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Thanks Suresh.

I agree, let's go YARN/MRv2 for the initial version of the Provisioning
Guide. Later revisions can deal with the more complex stuff.

Thanks,

Gunnar

On Tue, Feb 2, 2016 at 7:49 PM, Suresh Subbiah 
wrote:

> Hi Gunnar,
>
> Agree with everything you state above, except "However, YARN is required
> for some of the backup/restore..."
> I am sorry I said the wrong thing way up in this thread. backup/restore
> uses map reduce to copy files. I think it will work with both MRv1 and
> MRv2. So we should be good with this line alone "you install Hive and
> whatever version of MapReduce you want to use for Hive". backup/restore
> should be able to use the same version of MapReduce as the one Hive is
> using.
>
> However there is a caveat that Trafodion backup/restore use HBase's
> ExportSnapshot java class. If this class is changed such that it can use
> only MRv2 then we will have the same dependency. If we are looking for
> simple install instructions then maybe we should just say that MRv2 (YARN)
> is required and can be used for both Hive and backup/restore?
>
> Thanks
> Suresh
>
>
> On Tue, Feb 2, 2016 at 6:20 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> I am a bit lost. Per previous messages, Hive requires MapReduce. So,
>> MapReduce must be required for full function. I can see that MapReduce is
>> not required if you don't use the Hive functionality.
>>
>> The Jira Hans pointed to seems to suggest to use MapReduce in lieu of
>> YARN, which must mean MRv1 since MRv2 is part of YARN.
>>
>> From what I now understand, you install Hive and whatever version of
>> MapReduce you want to use for Hive. However, YARN is required for some of
>> the backup/restore capabilities so you always need to install MRv2 (since
>> its part of YARN). So, MRv1 is relevant ONLY IF your installation is using
>> MRv1 for Hive processing.
>>
>> Did I get that right?
>>
>> I don't think it's wise to discuss exceptions such as "you don't need
>> MapReduce if you don't plan to use Hive via Trafodion" in the first
>> revision of the Trafodion Provisioning Guide. Too many angles dancing on a
>> needle's head. Instead, let's keep the requirements as simple as we can.
>>
>> Thanks,
>>
>> Gunnar
>>
>> On Tue, Feb 2, 2016 at 3:44 PM, Amanda Moran 
>> wrote:
>>
>>> I have done many installs without Yarn or MapReduce installed at all.
>>> Trafodion runs fine :)
>>>
>>> On Tue, Feb 2, 2016 at 2:39 PM, Hans Zeller 
>>> wrote:
>>>
>>>> No, it is not required in the build environment.
>>>>
>>>> Hans
>>>>
>>>> On Tue, Feb 2, 2016 at 1:54 PM, Gunnar Tapper 
>>>> wrote:
>>>>
>>>>> Does this mean that MRv1 is now required in the build environment?
>>>>>
>>>>> On Tue, Feb 2, 2016 at 2:12 PM, Hans Zeller 
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> That decision would be made by Hive, not Trafodion. For people who
>>>>>> use install_local_hadoop, we recently changed that setup to use local
>>>>>> MapReduce, not YARN, see
>>>>>> https://issues.apache.org/jira/browse/TRAFODION-1781.
>>>>>>
>>>>>> Hans
>>>>>>
>>>>>> On Tue, Feb 2, 2016 at 12:58 PM, Gunnar Tapper <
>>>>>> tapper.gun...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi Suresh:
>>>>>>>
>>>>>>> Thanks for the information.
>>>>>>>
>>>>>>> Given from what you write, it seems that YARN with MRv2 is required
>>>>>>> for full functionality.
>>>>>>>
>>>>>>> MRv1 is a separate install in current distributions, which is why I
>>>>>>> am asking about it. How does Trafodion decide to run the MapReduce job 
>>>>>>> as
>>>>>>> MRv1 vs. MRv2 if both are installed?
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Gunnar
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah <
>>>>>>> suresh.subbia...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>&g

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Hi,

I am a bit lost. Per previous messages, Hive requires MapReduce. So,
MapReduce must be required for full function. I can see that MapReduce is
not required if you don't use the Hive functionality.

The Jira Hans pointed to seems to suggest to use MapReduce in lieu of YARN,
which must mean MRv1 since MRv2 is part of YARN.

>From what I now understand, you install Hive and whatever version of
MapReduce you want to use for Hive. However, YARN is required for some of
the backup/restore capabilities so you always need to install MRv2 (since
its part of YARN). So, MRv1 is relevant ONLY IF your installation is using
MRv1 for Hive processing.

Did I get that right?

I don't think it's wise to discuss exceptions such as "you don't need
MapReduce if you don't plan to use Hive via Trafodion" in the first
revision of the Trafodion Provisioning Guide. Too many angles dancing on a
needle's head. Instead, let's keep the requirements as simple as we can.

Thanks,

Gunnar

On Tue, Feb 2, 2016 at 3:44 PM, Amanda Moran  wrote:

> I have done many installs without Yarn or MapReduce installed at all.
> Trafodion runs fine :)
>
> On Tue, Feb 2, 2016 at 2:39 PM, Hans Zeller  wrote:
>
>> No, it is not required in the build environment.
>>
>> Hans
>>
>> On Tue, Feb 2, 2016 at 1:54 PM, Gunnar Tapper 
>> wrote:
>>
>>> Does this mean that MRv1 is now required in the build environment?
>>>
>>> On Tue, Feb 2, 2016 at 2:12 PM, Hans Zeller 
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> That decision would be made by Hive, not Trafodion. For people who use
>>>> install_local_hadoop, we recently changed that setup to use local
>>>> MapReduce, not YARN, see
>>>> https://issues.apache.org/jira/browse/TRAFODION-1781.
>>>>
>>>> Hans
>>>>
>>>> On Tue, Feb 2, 2016 at 12:58 PM, Gunnar Tapper >>> > wrote:
>>>>
>>>>> Hi Suresh:
>>>>>
>>>>> Thanks for the information.
>>>>>
>>>>> Given from what you write, it seems that YARN with MRv2 is required
>>>>> for full functionality.
>>>>>
>>>>> MRv1 is a separate install in current distributions, which is why I am
>>>>> asking about it. How does Trafodion decide to run the MapReduce job as 
>>>>> MRv1
>>>>> vs. MRv2 if both are installed?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Gunnar
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah <
>>>>> suresh.subbia...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I don't think Trafodion requires YARN for most activity.
>>>>>>
>>>>>> For Hive table access, Trafodion uses Hive metadata access Java API
>>>>>> and libhdfs to actually scan the data file. Therefore YARN is not needed
>>>>>> for Hive access.
>>>>>> YARN is not needed for native Hbase or Trafodion table access too.
>>>>>> YARN is needed for backup/restore, since the HBase exportSnapshot
>>>>>> class Trafodion calls, used MapReduce to copy large snapshot files 
>>>>>> to/from
>>>>>> the backup location.
>>>>>> YARN is also needed for developer regressions as some vanilla Hive
>>>>>> commands are executed during the regression run.
>>>>>> For the last 2 lines I think both MRv1 and MRv2 is supported.
>>>>>>
>>>>>> Thanks
>>>>>> Suresh
>>>>>>
>>>>>>
>>>>>> On Tue, Feb 2, 2016 at 2:36 PM, Gunnar Tapper <
>>>>>> tapper.gun...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> Does Trafodion require YARN with MRv2 or is MRv1 supported, too?
>>>>>>>
>>>>>>> --
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Gunnar
>>>>>>> *If you think you can you can, if you think you can't you're right.*
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks,
>>>>>
>>>>> Gunnar
>>>>> *If you think you can you can, if you think you can't you're right.*
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>>
>>> Gunnar
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Does this mean that MRv1 is now required in the build environment?

On Tue, Feb 2, 2016 at 2:12 PM, Hans Zeller  wrote:

> Hi,
>
> That decision would be made by Hive, not Trafodion. For people who use
> install_local_hadoop, we recently changed that setup to use local
> MapReduce, not YARN, see
> https://issues.apache.org/jira/browse/TRAFODION-1781.
>
> Hans
>
> On Tue, Feb 2, 2016 at 12:58 PM, Gunnar Tapper 
> wrote:
>
>> Hi Suresh:
>>
>> Thanks for the information.
>>
>> Given from what you write, it seems that YARN with MRv2 is required for
>> full functionality.
>>
>> MRv1 is a separate install in current distributions, which is why I am
>> asking about it. How does Trafodion decide to run the MapReduce job as MRv1
>> vs. MRv2 if both are installed?
>>
>> Thanks,
>>
>> Gunnar
>>
>>
>>
>> On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah <
>> suresh.subbia...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I don't think Trafodion requires YARN for most activity.
>>>
>>> For Hive table access, Trafodion uses Hive metadata access Java API and
>>> libhdfs to actually scan the data file. Therefore YARN is not needed for
>>> Hive access.
>>> YARN is not needed for native Hbase or Trafodion table access too.
>>> YARN is needed for backup/restore, since the HBase exportSnapshot class
>>> Trafodion calls, used MapReduce to copy large snapshot files to/from the
>>> backup location.
>>> YARN is also needed for developer regressions as some vanilla Hive
>>> commands are executed during the regression run.
>>> For the last 2 lines I think both MRv1 and MRv2 is supported.
>>>
>>> Thanks
>>> Suresh
>>>
>>>
>>> On Tue, Feb 2, 2016 at 2:36 PM, Gunnar Tapper 
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Does Trafodion require YARN with MRv2 or is MRv1 supported, too?
>>>>
>>>> --
>>>> Thanks,
>>>>
>>>> Gunnar
>>>> *If you think you can you can, if you think you can't you're right.*
>>>>
>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Thanks.

On Tue, Feb 2, 2016 at 2:36 PM, Hans Zeller  wrote:

> No, unless a user explicitly puts it into a UDF, none of the built-in UDFs
> and SPJs use MR.
>
> Hans
>
> On Tue, Feb 2, 2016 at 1:21 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> I think it's a configuration choice. For example:
>> http://www.cloudera.com/documentation/manager/5-0-x/Cloudera-Manager-Managing-Clusters/cm5mc_mapreduce_service.html
>>
>> Are there UDFs, SPJs, and similar functions that use MapReduce, too?
>>
>> Thanks,
>>
>> Gunnar
>>
>> On Tue, Feb 2, 2016 at 2:19 PM, Qifan Chen  wrote:
>>
>>>
>>> Hi Hans,
>>>
>>> I think Hive uses MapReduce to sort the data during table population,
>>> after disabling YARN. This is observed on a workstation.
>>>
>>> Thanks -Qifan
>>>
>>> On Tue, Feb 2, 2016 at 3:12 PM, Hans Zeller 
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> That decision would be made by Hive, not Trafodion. For people who use
>>>> install_local_hadoop, we recently changed that setup to use local
>>>> MapReduce, not YARN, see
>>>> https://issues.apache.org/jira/browse/TRAFODION-1781.
>>>>
>>>> Hans
>>>>
>>>> On Tue, Feb 2, 2016 at 12:58 PM, Gunnar Tapper >>> > wrote:
>>>>
>>>>> Hi Suresh:
>>>>>
>>>>> Thanks for the information.
>>>>>
>>>>> Given from what you write, it seems that YARN with MRv2 is required
>>>>> for full functionality.
>>>>>
>>>>> MRv1 is a separate install in current distributions, which is why I am
>>>>> asking about it. How does Trafodion decide to run the MapReduce job as 
>>>>> MRv1
>>>>> vs. MRv2 if both are installed?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Gunnar
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah <
>>>>> suresh.subbia...@gmail.com> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I don't think Trafodion requires YARN for most activity.
>>>>>>
>>>>>> For Hive table access, Trafodion uses Hive metadata access Java API
>>>>>> and libhdfs to actually scan the data file. Therefore YARN is not needed
>>>>>> for Hive access.
>>>>>> YARN is not needed for native Hbase or Trafodion table access too.
>>>>>> YARN is needed for backup/restore, since the HBase exportSnapshot
>>>>>> class Trafodion calls, used MapReduce to copy large snapshot files 
>>>>>> to/from
>>>>>> the backup location.
>>>>>> YARN is also needed for developer regressions as some vanilla Hive
>>>>>> commands are executed during the regression run.
>>>>>> For the last 2 lines I think both MRv1 and MRv2 is supported.
>>>>>>
>>>>>> Thanks
>>>>>> Suresh
>>>>>>
>>>>>>
>>>>>> On Tue, Feb 2, 2016 at 2:36 PM, Gunnar Tapper <
>>>>>> tapper.gun...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> Does Trafodion require YARN with MRv2 or is MRv1 supported, too?
>>>>>>>
>>>>>>> --
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Gunnar
>>>>>>> *If you think you can you can, if you think you can't you're right.*
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks,
>>>>>
>>>>> Gunnar
>>>>> *If you think you can you can, if you think you can't you're right.*
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Regards, --Qifan
>>>
>>>
>>
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Hi,

I think it's a configuration choice. For example:
http://www.cloudera.com/documentation/manager/5-0-x/Cloudera-Manager-Managing-Clusters/cm5mc_mapreduce_service.html

Are there UDFs, SPJs, and similar functions that use MapReduce, too?

Thanks,

Gunnar

On Tue, Feb 2, 2016 at 2:19 PM, Qifan Chen  wrote:

>
> Hi Hans,
>
> I think Hive uses MapReduce to sort the data during table population,
> after disabling YARN. This is observed on a workstation.
>
> Thanks -Qifan
>
> On Tue, Feb 2, 2016 at 3:12 PM, Hans Zeller  wrote:
>
>> Hi,
>>
>> That decision would be made by Hive, not Trafodion. For people who use
>> install_local_hadoop, we recently changed that setup to use local
>> MapReduce, not YARN, see
>> https://issues.apache.org/jira/browse/TRAFODION-1781.
>>
>> Hans
>>
>> On Tue, Feb 2, 2016 at 12:58 PM, Gunnar Tapper 
>> wrote:
>>
>>> Hi Suresh:
>>>
>>> Thanks for the information.
>>>
>>> Given from what you write, it seems that YARN with MRv2 is required for
>>> full functionality.
>>>
>>> MRv1 is a separate install in current distributions, which is why I am
>>> asking about it. How does Trafodion decide to run the MapReduce job as MRv1
>>> vs. MRv2 if both are installed?
>>>
>>> Thanks,
>>>
>>> Gunnar
>>>
>>>
>>>
>>> On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah <
>>> suresh.subbia...@gmail.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I don't think Trafodion requires YARN for most activity.
>>>>
>>>> For Hive table access, Trafodion uses Hive metadata access Java API and
>>>> libhdfs to actually scan the data file. Therefore YARN is not needed for
>>>> Hive access.
>>>> YARN is not needed for native Hbase or Trafodion table access too.
>>>> YARN is needed for backup/restore, since the HBase exportSnapshot class
>>>> Trafodion calls, used MapReduce to copy large snapshot files to/from the
>>>> backup location.
>>>> YARN is also needed for developer regressions as some vanilla Hive
>>>> commands are executed during the regression run.
>>>> For the last 2 lines I think both MRv1 and MRv2 is supported.
>>>>
>>>> Thanks
>>>> Suresh
>>>>
>>>>
>>>> On Tue, Feb 2, 2016 at 2:36 PM, Gunnar Tapper 
>>>> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> Does Trafodion require YARN with MRv2 or is MRv1 supported, too?
>>>>>
>>>>> --
>>>>> Thanks,
>>>>>
>>>>> Gunnar
>>>>> *If you think you can you can, if you think you can't you're right.*
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>>
>>> Gunnar
>>> *If you think you can you can, if you think you can't you're right.*
>>>
>>
>>
>
>
> --
> Regards, --Qifan
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Trafodion 1.3 and Hortonworks

[Gunnar Tapper]

Hi Amanda,

Thanks for the CDH clarification.

What about HDP?

Thanks,

Gunnar

On Tue, Feb 2, 2016 at 2:05 PM, Amanda Moran  wrote:

> Trafodion support CDH 5.2 and 5.3 both on HBase 0.98.
>
> On Tue, Feb 2, 2016 at 1:04 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> It's my understanding that Trafodion supports both CDH 5.4.4 and CDH
>> 5.4.5 and, therefore, HBase 1.0.
>>
>> What about HDP 2.2? It uses HBase 0.98.4.
>>
>> *working on the 1.3 Provisioning Guide*
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Trafodion 1.3 and Hortonworks

[Gunnar Tapper]

Hi,

It's my understanding that Trafodion supports both CDH 5.4.4 and CDH 5.4.5
and, therefore, HBase 1.0.

What about HDP 2.2? It uses HBase 0.98.4.

*working on the 1.3 Provisioning Guide*

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: MRv1 vs. MRv2

[Gunnar Tapper]

Hi Suresh:

Thanks for the information.

Given from what you write, it seems that YARN with MRv2 is required for
full functionality.

MRv1 is a separate install in current distributions, which is why I am
asking about it. How does Trafodion decide to run the MapReduce job as MRv1
vs. MRv2 if both are installed?

Thanks,

Gunnar



On Tue, Feb 2, 2016 at 1:50 PM, Suresh Subbiah 
wrote:

> Hi,
>
> I don't think Trafodion requires YARN for most activity.
>
> For Hive table access, Trafodion uses Hive metadata access Java API and
> libhdfs to actually scan the data file. Therefore YARN is not needed for
> Hive access.
> YARN is not needed for native Hbase or Trafodion table access too.
> YARN is needed for backup/restore, since the HBase exportSnapshot class
> Trafodion calls, used MapReduce to copy large snapshot files to/from the
> backup location.
> YARN is also needed for developer regressions as some vanilla Hive
> commands are executed during the regression run.
> For the last 2 lines I think both MRv1 and MRv2 is supported.
>
> Thanks
> Suresh
>
>
> On Tue, Feb 2, 2016 at 2:36 PM, Gunnar Tapper 
> wrote:
>
>> Hi,
>>
>> Does Trafodion require YARN with MRv2 or is MRv1 supported, too?
>>
>> --
>> Thanks,
>>
>> Gunnar
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>


-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

MRv1 vs. MRv2

[Gunnar Tapper]

Hi,

Does Trafodion require YARN with MRv2 or is MRv1 supported, too?

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: How to Update the Apache Trafodion Website...

[Gunnar Tapper]

Hi,

Don't bother. It'll be replaced with the upcoming Trafodion Provision Guide.

But, in general, all these how-to instructions are now documented in the
Trafodion Contributor Guide:
https://cwiki.apache.org/confluence/display/TRAFODION/Trafodion+Contributor+Guide

Gunnar

On Tue, Feb 2, 2016 at 11:30 AM, Amanda Moran 
wrote:

> Hi there All-
>
> I would like to update the installation page on the Apache Trafodion
> Website. It's too complicated right now, and doesn't flow correctly.
>
> Can we please have the steps to that in bullet points here? A link to the
> page on the website would also be fine.
>
> Thanks.
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: Apache Trafodion release

[Gunnar Tapper]

Great job Roberta!

On Wed, Jan 20, 2016 at 9:07 AM, Roberta Marton 
wrote:

> My term as Release Manager for Apache Trafodion release 1.3.0 has been
> completed.  It has been a pleasure working with the different Apache teams
> and Trafodion mentors, committers, and contributors.
>
> Now that release 1.3.0 is available, we are starting to working on our
> next release in about 6 to 8 weeks.  For the next release we would like to:
>
> a.   Release binaries along with the source tar file
>
> b.  Support vanilla releases for Hadoop and HBase
>
> c.   Improve the build process (ongoing)
>
> If you have any comments on these items or would like to see other items
> included please respond to this email.
>
>
>
> Before I sign-off, I would like to recap the work that went into this
> release.  This was our first Apache Incubator release but we did several
> open source releases before joining Apache.  The following is the list of
> new features we added since our last non Apache open source release:
>
> -  IDENTITY columns in SQL
>
> -  HBase region splitting and re-balancing with active transaction
>
> -  Support for batch feature in Installer
>
> -  Cloudera parcels feature in Installer
>
> -  Phase 1 of multi-temperate data in SQL
>
> -  Compile time interface for Table Mapping UDFs
>
> -  Allow columns attributes to be changes on table for SQL
>
> -  Enable HBase serialization feature
>
> -  Enable EXPLAIN_IN_RMS feature
>
> -  Reduc path length for IUD operations
>
> -  Enable compressed Internal Format for the scan operator
>
> -  Many build improvements
>
> In addition we fixed over 100 JIRA's.
>
> Finally and more importunately, I would like to thank everyone who helped
> with the release.  I received tremendous support from everyone.  Special
> thanks go to:
>
> -  Sandhya Sundaresan who spent weeks adding Apache license text
> and getting Apache RAT to run without incident.
>
> -  Anu Hedge for simplifying the Trafodion build by unifying
> several build steps into a simple make operation.
>
> -  Hans Zeller for providing many changes including build
> improvements to integrate SQL Java builds and removing the requirement for
> consumers to download and build specific versions of Hadoop and HBase.
>
> -  Steve Varnau who was invaluable in answering all my build
> questions, fixing all my git errors and helping with setting up the release
> 1.3 directories and artifacts
>
> -  Amanda Moran who tested all the binary artifacts created by
> the source builds on different Hadoop installations.
>
> -  Gunnar Tapper who worked countless hours designing and
> implementing our revamped Apache Trafodion web site – go check it out!
>
> -  Kevin Deyager and Justin Mclean for helping with licensing and
> copyright issues
>
> -  Many Trafodion contributors whom I pestered with questions
> where were competently answered, and then reviewed changes to the product.
>
> -  Michael Stack and Devaraj Das for handling mentoring tasks.
>
>Regards,
>
>Roberta
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

[ANNOUNCE] Trafodion Documentation Updated on Website

[Gunnar Tapper]

Hi,

The new Trafodion documentation has been published on the Trafodion
website: http://trafodion.apache.org/documentation.html

Enjoy!

-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*