Trafodion中文安装手册

今天发现一个中文的Trafodion安装手册。发上来分享一下。 林海 安装Trafodion集群.doc Description: MS-Word document

答复: Trafodion中文安装手册

非常值得参考，谢谢。 发件人: HenryLin [mailto:henry@139.com] 发送时间: 2016年2月3日 17:09 收件人: user@trafodion.incubator.apache.org 主题: Trafodion中文安装手册 今天发现一个中文的Trafodion安装手册。发上来分享一下。 林海

cqd mode_seahive 'ON'

Hello, I am playing with trafodion hive access path, and I see in some of the regression test about hive a CQD mode_seahive ‘ON’. However, looking in the SQL reference manual, I don’t see this CQD in the hive CQD section. Is this CQD important? Or can I just forget about it? Thanks in advance f

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.*

RE: cqd mode_seahive 'ON'

this cqd was added when we initially added support for hive/hdfs tables from trafodion. It was at that time used for testing and/or to enable hive access selectively. It is now on by default in traf code and doesn’t need to be set explicitly. anoop From: Eric Owhadi [mailto:eric.owh...@

RE: cqd mode_seahive 'ON'

Thanks Anoop for the quick help, Eric *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com] *Sent:* Wednesday, February 3, 2016 10:55 AM *To:* user@trafodion.incubator.apache.org *Subject:* RE: cqd mode_seahive 'ON' this cqd was added when we initially added support for hive/hdfs tables from

RE: Trafodion 1.3 and Hortonworks

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,

Re: Trafodion 1.3 and Hortonworks

+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.

Re: Trafodion 1.3 and Hortonworks

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

RE: Trafodion's usage of Except

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@trafo

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 en

question on nullable column in primary key and impact on upsert

This following question is about checking if adding nullable columns on PK for the sake of data partitioning can be done without too much impact on initial PK uniqueness semantic… specially for upsert statements… If I have a composite primary key with column A and B. A nullable B non nullable

RE: question on nullable column in primary key and impact on upsert

Hi Eric, Seems like this business of adding a nullable column to the primary key for partitioning purposes creates a lot of headaches. By doing so, it changes the definition of the primary key for the table. But then it appears in the UPSERT scenario, you really wanted the old primary key, not t

RE: question on nullable column in primary key and impact on upsert

Talking about can of worms, if we start allowing NULLable columns in the Primary Key we will probably find a number of things might break or not work correctly, since we make a lot of assumptions about those Primary Key columns, as Qifan pointed out. *From:* Dave Birdsall [mailto:dave.birds...@e

RE: question on nullable column in primary key and impact on upsert

Hi Dave I am aware of the implication you mention. But for BI scenario, we don’t use key access for single row retrieval and we can always make sure we can supply the partitioning column. So no big deal. I agree that the limitation on STORE BY would be more elegant, since it will not force a non-n

Re: question on nullable column in primary key and impact on upsert

Hi Eric, A JIRA will be nice for this failure. These predicates are generated and I have made a mistake in not considering ISNULL predicates here. A fix will be straightforward. >>upsert into t values(null,2); *** ERROR[4099] A NULL operand is not allowed in predicate (TRAFODION.TPCDSGOOD.T.A

RE: question on nullable column in primary key and impact on upsert

JIRA 1811 created, thanks Suresh J. I don’t know if the 2 other issues are cascade from the error you will fix, we will see. The JIRA mention the 3… *From:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com] *Sent:* Wednesday, February 3, 2016 2:33 PM *To:* user@trafodion.incubator.apache.org *S

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 ca

RE: Trafodion user security

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's usage of Except

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-cp

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 ov

RE: Trafodion user security

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 prer

Re: 答复: Trafodion's usage of Except

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

Re: Trafodion user security

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 pr

traf_*mods in trafodion installation

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