Re: Question on JIRA's

2015-07-01 Thread Selva Govindarajan
Trafodion was using gerrit before it become a apache incubator project. Does github have a mechanism to vote for a commit as +2, +1 or -1.like gerrit had? If not, how should the reviewers communicate this to the committers. Selva On Wed, Jul 1, 2015 at 7:02 AM, Moran, Amanda wrote: > Pierre- >

Re: Project Merge criteria

2015-07-07 Thread Selva Govindarajan
To start with, I would think we should enable the capability to do full test using hub. Currently, only subset of tests are being done as part of the commit. Depending upon the nature of the commit, I would think the contributor can choose to run the full test or the reviewer can request the contr

Re: Email addresses in Contributors page in wiki (was Re: Anyone working....)

2015-07-10 Thread Selva Govindarajan
can you please add me too. My jira id is selvag On Fri, Jul 10, 2015 at 12:56 PM, Qifan Chen wrote: > Yes, I was able to. Thank you! > > On Fri, Jul 10, 2015 at 2:05 PM, Stack wrote: > > > On Fri, Jul 10, 2015 at 11:50 AM, Qifan Chen > wrote: > > > > > Hi, > > > > > > My JIRA user name is qfc

Re: Assignment of Trafodion JIRAs

2015-07-13 Thread Selva Govindarajan
Hi Dave, Trafodion contributors are not able to self-assign if the JIRA is created by others. But, the committers were able to assign the JIRA to the contributors. Suresh assigned one to me. However, I couldn't find a way to mark the JIRA as resolved even when it is assigned to me. Can only the cr

Fwd: ICLA of Selvaganesan Govindarajan

2015-07-13 Thread Selva Govindarajan
My JIRA id is selvag My github id is selvaganesang Selva -- Forwarded message -- From: Selvaganesan Govindarajan Date: Sun, Jul 12, 2015 at 12:08 PM Subject: Fwd: ICLA of Selvaganesan Govindarajan To: selva.govindara...@esgyn.com -- Forwarded message -- From: Cr

Re: Disk space usage

2015-07-15 Thread Selva Govindarajan
Hi Layala, You can initiate major compaction manually by issuing the following commands in hbase shell flush '' major_compact '' Usually, major_compact is initiated as per the compact policy set in hbase configuration. This link http://www.slideshare.net/cloudera/hbasecon-2013-compaction-improv

Re: Learning the code, help would be appreciated

2015-07-15 Thread Selva Govindarajan
Hi Eric, Here is brief summary of the Trafodion execution engine code structure. I hope this would help you to set the breakpoint. cli directory contains the implementation of Call level Interfaces from the application like sqlci, mxosrvr. executor directory contains the implementation for all th

RE: optimization of deleteColumns?

2015-07-21 Thread Selva Govindarajan
Hi Eric, I believe this code is used to drop a column from all rows in the trafodion table to support ALTER TABLE .. DROP COLUMN command. Yes. It is possible to optimize the code further. Drop column is rarely used and hence I guess this part of the code didn’t come under radar for improvement.

RE: optimization of deleteColumns?

2015-07-22 Thread Selva Govindarajan
and one will never reach the point of > selecting it from the table. > However, if a column is later added with the same name, then incorrect > results will be returned due to existing column values that were not > deleted during the drop command. > > anoop > > -Original Me

Re: optimization of deleteColumns?

2015-07-22 Thread Selva Govindarajan
lete Rows on each > thread to unsure that rows to delete on a multiple delete are from same > region. > > I agree that coproc would be the fastest method, but is it worth going that > route given the limited scenario? > > Eric > > -Original Message- > From: Selv

RE: Re: Index usage

2015-07-29 Thread Selva Govindarajan
I think there is some issue. I have attached the invoke of the table. When the query involves index t12i1 it chooses the index plan even for the queries with the predicates. When the query involves index t12i2, the index is not chosen unless it is full index scan. The index t12i2 is salted while t

RE: Re: Index usage

2015-07-29 Thread Selva Govindarajan
that there is no need to access the base table rows. Layala, Is the index created as salted? If so, it might be worth creating the index with no salting and try out the query to confirm if it chooses the index plan. Selva -Original Message- From: Selva Govindarajan [mailto:selva.govi

RE: Re: Index usage

2015-07-29 Thread Selva Govindarajan
ht be worth creating the index with no salting and try out the query to confirm if it chooses the index plan. Selva -----Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Wednesday, July 29, 2015 8:05 AM To: 'dev@trafodion.incubator.apache.org' ;

RE: Index Type

2015-08-06 Thread Selva Govindarajan
Hi Layala, Trafodion doesn't use the secondary index concept in Hbase. It is just another table with index columns and primary key. The consistency between the tables and indexes is achieved using Trafodion Transaction Manager. Selva -Original Message- From: Martin, Layla (HP DualStudy)

RE: not sure about behavior of CQD?

2015-08-07 Thread Selva Govindarajan
I think this is the expected behavior. When the option is system, it takes the default value(internally referred as default defaults). The default value can be changed by setting the CQD in the default table. Selva -Original Message- From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent:

RE: question on regression test development with update statistics

2015-08-11 Thread Selva Govindarajan
If the table name are different, then there should be a separate entry in NATable cache for each of them. If these attributes are part of NATable, then there is no need to invalidate the cache entry. If the table names are same (you dropped the table and created the table with the same name but wi

Contributions not accounted since July in incubator-trafodion repo

2015-08-13 Thread Selva Govindarajan
" = "$OLD_EMAIL" ] then export GIT_AUTHOR_NAME="$CORRECT_NAME" export GIT_AUTHOR_EMAIL="$CORRECT_EMAIL" fi ' --tag-name-filter cat -- --branches –tags’ End of script – Do not include this line. *From:* Jamie Murai (GitHub Staff) [mailto:sup

RE: Contributions not accounted since July in incubator-trafodion repo

2015-08-21 Thread Selva Govindarajan
AM To: dev@trafodion.incubator.apache.org Subject: RE: Contributions not accounted since July in incubator-trafodion repo Hi Selva, I never followed up on this. Fell through the cracks. Is there anything you want me to do? Dave -Original Message----- From: Selva Govindarajan [mailto:selva.govindara...

RE: [Urgent Help] Trafodion Build Environment Problem

2015-09-08 Thread Selva Govindarajan
The whole Trafodion stack may not have been tested for pids more than 65K. However, the problems with pids more than 65k will be first observed by mxssmp or mxsscp processes and it dumps core. These processes provide the capability to trouble shoot problems with query execution in Trafodion infrast

RE: [Urgent Help] Trafodion Build Environment Problem

2015-09-08 Thread Selva Govindarajan
Hi Amanda, I presume that the installer will flag this as a requirement for Trafodion to be installed. Will it abort the installation or will the installer fix the pid_max settings automatically. Selva -Original Message- From: Amanda Moran [mailto:amanda.mo...@esgyn.com] Sent: Tuesday, S

RE: odbc and/or hammerdb logs

2015-09-15 Thread Selva Govindarajan
Hi Radu, Thanks for using Trafodion. With the help from Suresh, we looked at the core files in your cluster. We believe that there are two scenarios that is causing the Trafodion processes to dump core. Scenario 1: Core dumped by tdm_arkesp processes. Trafodion engine has assumed the entity /proc

RE: odbc and/or hammerdb logs

2015-09-16 Thread Selva Govindarajan
m.TmAuditTlog: disableBlockCache is >> false >> 2015-09-14 12:21:52,229 INFO dtm.HBaseAuditControlPoint: >> disableBlockCache is false >> 2015-09-14 12:21:52,233 INFO dtm.HBaseAuditControlPoint: useAutoFlush >> is false >> 2015-09-14 12:42:57,346 INFO dtm.HBaseTxClient: Exit R

RE: odbc and/or hammerdb logs

2015-09-18 Thread Selva Govindarajan
FDS (msg1=0x43c070 > > >> > >>>> > "Trafodion > UDR > > >> > Server > > >> > >>>> > Internal Error", msg2=, > > msg3=0x7fff119787f0 > > >> > >>>> "Source > > >> > >>>> > file in

RE: trafodion won't start core files are generated

2015-10-07 Thread Selva Govindarajan
You would want to retain the shared segment size across reboots. So, please check if the following settings are available in /etc/sysctl.conf # Controls the maximum shared segment size, in bytes kernel.shmmax = 134217728 # Controls the maximum number of shared memory segments, in pages kernel.shm

RE: compiling in release mode?

2015-10-21 Thread Selva Govindarajan
I think you are mixing the release objects with the debug environment. To build and use the release version, Start a new terminal session ( assumption is that Trafodion environment files are not invoked in .bashrc or any startup files) cd /core/sqf . ./sqenvr.sh cd ../.. make clean make all Mak

RE: compiling in release mode?

2015-10-21 Thread Selva Govindarajan
in release mode? Do you have to redo sqgen? Roberta -Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Wednesday, October 21, 2015 3:39 PM To: dev@trafodion.incubator.apache.org Subject: RE: compiling in release mode? I think you are mixing the

RE: SERIALIZED option on columns

2015-10-27 Thread Selva Govindarajan
This JIRA https://issues.apache.org/jira/browse/TRAFODION-1462 has excellent documentation written by Suresh on this topic. Selva -Original Message- From: Anoop Sharma [mailto:anoop.sha...@esgyn.com] Sent: Tuesday, October 27, 2015 10:34 AM To: dev@trafodion.incubator.apache.org Subject: R

RE: Aligned format?

2015-10-27 Thread Selva Govindarajan
You can find the format documentation at exp/ExpAlignedFormat.h Selva -Original Message- From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Tuesday, October 27, 2015 1:03 PM To: dev@trafodion.incubator.apache.org Subject: Aligned format? H All, Would like to learn about Aligned form

RE: question on NULL representation in DB?

2015-10-29 Thread Selva Govindarajan
By default, the null values are not inserted into hbase. If the column is nullable, the first additional byte determines if the column value is null or not. When a value is inserted into nullable column the first byte is always 0x00. When the column value is updated to null, the existing column val

RE: question on NULL representation in DB?

2015-10-30 Thread Selva Govindarajan
of expression eval during select or during update. Thanks Suresh On Thu, Oct 29, 2015 at 1:34 PM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > By default, the null values are not inserted into hbase. If the column > is nullable, the first additional byte determines

RE: Trafodion and core file location ?

2015-11-12 Thread Selva Govindarajan
When an application dumps core by issuing abort() or exit(non_zero_value), the core location is usually determined by /proc/sys/kernel/core_pattern. When Trafodion engine explicitly dump core for certain conditions like dumping ssmp core before bringing down the node, we might be able to control th

RE: Is anyone else seeing this?

2015-11-17 Thread Selva Govindarajan
Hi Dave, I have run the full regressions with Trafodion 2.0 with no issues. By any chance have you mixed the debug and release environments - meaning started Hbase when you were in release mode and then switched to debug mode to start Trafodion instance or vice versa. I have encountered this kind

RE: Nifty trick

2015-12-04 Thread Selva Govindarajan
There is yet another way: Issue show remoteprocess in the trafci command. But debugging mxosrvr would a bit tricky, because zookeeper would timeout the connection between the client and server. You need to increase the timeout using a property in dcs-site.xml Selva -Original Message- Fr

RE: enhance TRANSLATE to support Chinese charset?

2015-12-21 Thread Selva Govindarajan
Hi Ming, Currently, Trafodion hive scan doesn't support UCS2 or a character set with embedded null byte. Is GBK a double byte character set with null byte embedded in character data to represent characters? If so, you might consider making the Trafodion hive scan to be double byte character set aw

RE: Checking up on pull requests

2015-12-22 Thread Selva Govindarajan
PR 227 is not yet ready to merge. I have added the comment in the PR that I am still working on the final fix. Selva -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Tuesday, December 22, 2015 10:04 AM To: dev@trafodion.incubator.apache.org Subject: RE: Checki

RE: [VOTE] Apache Trafodion release 1.3.0 ready for release - release candidate 5

2015-12-23 Thread Selva Govindarajan
Hello St.Ack, make package make package-all at the same directory where "make all" was issued should create the tar.gz files needed. The website shows the following: Command What It Builds make allTrafodion, DCS, and REST. make packageTrafodion, DCS, REST, an

RE: [VOTE] Apache Trafodion release 1.3.0 ready for release - release candidate 5

2015-12-24 Thread Selva Govindarajan
les. To create tar file, do "make package". I believe > the tar files are created in the distribution directory off the main > Trafodion directory. > > We used to have this section included with the build page but moved it > onto a separate page. > >Roberta >

RE: [VOTE] Apache Trafodion release 1.3.0 ready for release - release candidate 5

2015-12-24 Thread Selva Govindarajan
Roberta -Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Thursday, December 24, 2015 10:14 AM To: dev@trafodion.incubator.apache.org Subject: RE: [VOTE] Apache Trafodion release 1.3.0 ready for release - release candidate 5 Hi Stack, You need

RE: [VOTE] Apache Trafodion release 1.3.0 ready for release - release candidate 5

2015-12-24 Thread Selva Govindarajan
of a list of default answers for the installer. This question should probably be changed to be more clear. Hans On Thu, Dec 24, 2015 at 11:13 AM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > Hi Stack, > > I just did the following: > > cd $MY_SQROOT/.. > m

RE: 答复: enhance TRANSLATE to support Chinese charset?

2016-01-05 Thread Selva Govindarajan
Hi Ming, I believe Hive doesn't have a way to specify the character set encoding of individual columns. It relies on the JVM default encoding for the table as a whole. The JVM default encoding depends on the file.encoding default or the LANG variable. In Trafodion, we currently support TEXT and S

RE: enhance TRANSLATE to support Chinese charset?

2016-01-06 Thread Selva Govindarajan
o translate to another character set; we tried this in > > > >> > one of our > > > >> predecessor > > > >> > products and it caused endless complications -- it is > > > >> > technical debt > > > >> that > > > >> &

RE: core/TESTRTS failing?

2016-01-07 Thread Selva Govindarajan
] Sent: Thursday, January 7, 2016 7:01 AM To: dev@trafodion.incubator.apache.org Subject: RE: core/TESTRTS failing? So from a semantic standpoint it is normal to have these diffs? They should be filtered out? If so, I can make the change to make it pass? Eric -Original Message- From: Selva

RE: core/TESTRTS failing?

2016-01-07 Thread Selva Govindarajan
out, resulting in 53% decrease in byte read. So I will not filter this out, I will create a new EXPECTED TESTRTS, anything going back to non optimized value should fail test. Thanks for your help identifying the meaning of this number, Eric -Original Message- From: Selva Govindarajan

RE: core/TESTRTS failing?

2016-01-07 Thread Selva Govindarajan
o non optimized value should fail test. Thanks for your help identifying the meaning of this number, Eric -Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Thursday, January 7, 2016 9:57 AM To: dev@trafodion.incubator.apache.org Subject: RE: core/TESTRTS fa

RE: HBase Directories

2016-02-11 Thread Selva Govindarajan
/bulkload - Used by Trafodion bulk load command - Load into tablename command and also used as the temp. directory to create links to the actual hfiles for snapshot scanning. Selva -Original Message- From: Gunnar Tapper [mailto:tapper.gun...@gmail.com] Sent: Thursday, February 11, 2016 10

RE: Mxosrvr cores from phoenix tests

2016-02-18 Thread Selva Govindarajan
RE: Mxosrvr cores from phoenix tests I looked at the core file. The core file indicates that the query is UPSERT INTO DescColumnSortOrderTest (id,date1) VALUES(?,?) Can we attempt to reproduce this issue using sqlci? We need to take the test case and execute the similar commands in sqlci to ch

RE: missing $MY_SQROOT/etc/traf_coprocessor.properties

2016-02-25 Thread Selva Govindarajan
I think sqgen just copies this file from sql/scripts directory to etc directory. I believe this file is created in the scripts directory by install_local_hadoop. Selva -Original Message- From: Narendra Goyal [mailto:narendra.go...@esgyn.com] Sent: Thursday, February 25, 2016 8:20 AM To: d

RE: missing $MY_SQROOT/etc/traf_coprocessor.properties

2016-02-25 Thread Selva Govindarajan
: Thursday, February 25, 2016 8:41 AM To: dev@trafodion.incubator.apache.org Subject: RE: missing $MY_SQROOT/etc/traf_coprocessor.properties Very nice, Sqgen got me back on my feet. Thanks for the help :-), Eric -Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com

RE: build Trafodion with jdk 1.8 failed

2016-02-29 Thread Selva Govindarajan
With JDK 1.8, dcs and rest components failed to build. Thanks to Nitin for providing the command line option. I have made the needed change in the pom.xml with the help of Venkat. I am now able to build it with Jdk 1.8. I will deliver this change when Trafodion is ready to use jdk1.8 Selva -

RE: Noob question on working with Git

2016-03-03 Thread Selva Govindarajan
Creating branches, switching branches, stashing the changes or committing the changes temporarily all within one workspace have worked for me. I also switch from debug to release build within the same workspace. I use release build to run the full regressions because it runs faster. I only clone

RE: Jira cleanup

2016-03-15 Thread Selva Govindarajan
Are you able to mark it as resolved? You can add the link to the PR in the comments section. Selva -Original Message- From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Tuesday, March 15, 2016 11:26 AM To: dev@trafodion.incubator.apache.org Subject: RE: Jira cleanup That may be relat

RE: investigating parallel scanner

2016-03-22 Thread Selva Govindarajan
My understanding is that we haven't capitalized on the hbase feature of returning rows in order in Trafodion optimizer. So, if the tuple needs to flow in sorted order, it would add sort operator. Selva -Original Message- From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] Sent: Tuesday, Mar

RE: NUMERIC? NUMERIC!

2016-03-29 Thread Selva Govindarajan
It looks like showddl preserves the data type as given by the user >create table t2_big (c1 numeric(25,6)); --- SQL operation complete. >>showddl t2_big ; .. CREATE TABLE TRAFODION.SCH.T2_BIG ( C1 NUMERIC(25, 6) DEFAULT NULL NOT SERIALIZED ) ; Numeric col

RE: problem_with_server_read

2016-03-29 Thread Selva Govindarajan
Hi Pierre, Are you seeing any core dump of the mxosrvr? The core is dumped at the location based on /proc/sys/kernel/core_pattern. Selva -Original Message- From: Pierre Smits [mailto:pierre.sm...@gmail.com] Sent: Tuesday, March 29, 2016 11:35 AM To: dev@trafodion.incubator.apache.org S

RE: problem_with_server_read

2016-03-30 Thread Selva Govindarajan
you want me too). Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Tue, Mar 29, 2016 at 8:41 PM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > Hi Pierre,

RE: problem_with_server_read

2016-03-30 Thread Selva Govindarajan
ttp://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Wed, Mar 30, 2016 at 5:33 PM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > Hi Pierre, > > The hs_err log file gives some info. Please send

RE: problem_with_server_read

2016-04-01 Thread Selva Govindarajan
services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Wed, Mar 30, 2016 at 5:46 PM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > Yes. I believe so. > > Selva > > -Original Message- > From: Pierre Smits [mailto:pierre.sm...@gmail.com]

RE: problem_with_server_read

2016-04-01 Thread Selva Govindarajan
rketplace > http://oem.ofbizci.net/oci-2/ > > On Fri, Apr 1, 2016 at 4:28 PM, Selva Govindarajan < > selva.govindara...@esgyn.com> wrote: > >> Hi Pierre, >> >> Do you mean the link to the core file? I didn't receive it. I looked >> at the JIRA

RE: problem_with_server_read

2016-04-01 Thread Selva Govindarajan
wNVE/view?usp=sharing Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Fri, Apr 1, 2016 at 4:50 PM, Selva Govindarajan < selva.govindara...@esgyn.com> wrote: > Than

RE: Trafodion 2.0 & Java

2016-04-01 Thread Selva Govindarajan
Yes., maven build scripts need some changes for some of the Trafodion components java programs to compile. Selva -Original Message- From: Amanda Moran [mailto:amanda.mo...@esgyn.com] Sent: Friday, April 1, 2016 5:09 PM To: dev@trafodion.incubator.apache.org Subject: Re: Trafodion 2.0 & Jav

RE: Trafodion 2.0 & Java

2016-04-02 Thread Selva Govindarajan
ge, need more careful consideration > of all. We should understand all side effort of it before we can made > the change. The major concern is compatibility of various components, > not only Trafodion, but also HDFS, HBase, Zookeeper, Hive, etc... If > all are moved to JDK 8, Trafodion

RE: Trafodion master Daily Test Result - 165

2016-04-04 Thread Selva Govindarajan
RE: Trafodion master Daily Test Result - 165 These changes seem to help to build successfully. It looks like Trafodion become too specific to a particular build of HDP. Selva index 3295b30..5c0b5a0 100644 --- a/core/sqf/sqenvcom.sh +++ b/core/sqf/sqenvcom.sh @@ -142,8 +142,8 @@ export SQ

RE: Trafodion build failure with HDP

2016-04-04 Thread Selva Govindarajan
d to > > > build all the versions everytime. Cdh, hdp and vanilla Apache. > > > But the nightly build each night should probably build all 3 > > > versins to ensure they are working fine. > > > Any comments ? > > > > > > Developers shou

RE: Trafodion master Daily Test Result - 167 - Still Failing

2016-04-06 Thread Selva Govindarajan
I think it looks like a class path issue for hive tests in CDH. Need to be analyzed in CDH vm. Selva -Original Message- From: Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] Sent: Wednesday, April 6, 2016 7:48 AM To: dev@trafodion.incubator.apache.org Subject: RE: Trafodion mast

RE: Trafodion master Daily Test Result - 167 - Still Failing

2016-04-06 Thread Selva Govindarajan
crack at this one? --Steve > -Original Message- > From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] > Sent: Wednesday, April 6, 2016 9:19 AM > To: dev@trafodion.incubator.apache.org > Subject: RE: Trafodion master Daily Test Result - 167 - Still Failing > >

RE: Trafodion master Daily Test Result - 167 - Still Failing - Change in sqenvcom.sh

2016-04-06 Thread Selva Govindarajan
o debug it. Who would like a crack at this one? --Steve > -Original Message----- > From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com ] > Sent: Wednesday, April 6, 2016 9:19 AM > To: dev@trafodion.incubator.apache.org > Subject: RE: Trafodion master Daily Test Res

RE: Trafodion master Daily Test Result - 167 - Still Failing - Change in sqenvcom.sh

2016-04-06 Thread Selva Govindarajan
RE: Trafodion master Daily Test Result - 167 - Still Failing - Change in sqenvcom.sh It looks like color didn’t show up in the message correctly. Line 351 was added. _ *From:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com ] *Sent:* Wednesday

Change in sqenvcom.sh - Response required

2016-04-06 Thread Selva Govindarajan
Change in sqenvcom.sh - Response required Changed the subject line to avoid filtering…. _ *From:* Selva Govindarajan [mailto:selva.govindara...@esgyn.com ] *Sent:* Wednesday, April 6, 2016 3:25 PM *To:* 'dev@trafodion.incubator.apache.org&#

RE: Trafodion master Daily Test Result - 168 - Still Failing

2016-04-07 Thread Selva Govindarajan
Steve, The hive test failures are already analyzed. I am waiting for the community input about the change in sqenvcom.sh. Please feel free to make the change if it looks appropriate for you. The change is The line 351 is added to sqenvcom.sh. 347 # directories with jar files and list of

RE: Change in sqenvcom.sh - Response required

2016-04-07 Thread Selva Govindarajan
t; > I wonder if Steve could comment on the Jenkins angle? > > Dave > > -Original Message- > From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] > Sent: Wednesday, April 6, 2016 3:56 PM > To: dev@trafodion.incubator.apache.org > Subject: Change in sqenvcom

Re: In sqlci: how to show column names and associated data types?

2016-04-07 Thread Selva Govindarajan
You can either issue invoke trafodion..tablename or showddl trafodion..tablename Showddl output is such that it can be used to re-create the table when needed. Selva On Thu, Apr 7, 2016 at 11:52 AM, Pierre Smits wrote: > Hi all, > > Maybe this is question answered in the documentation/pages a

RE: Align format and NAColumn?

2016-04-15 Thread Selva Govindarajan
Hi Eric, What gets stored in hbase should be the straight dump of aligned format as explained in exp/ExpAlignedFormat.h. Selva -Original Message- From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Friday, April 15, 2016 9:12 AM To: dev@trafodion.incubator.apache.org Subject: RE: Alig

RE: Using Eclipse to debug Trafodion Java code

2016-04-21 Thread Selva Govindarajan
For mxosrvr, ESP or any Trafodion SQL process, the debug port number would be the $JVM_DEBUG_PORT/1000 + 1000th modulo of the pid of the process For eg if JVM_DEBUG_PORT is 24000 and pid of the process is 35580 Port no to use is 24580 Selva -Original Message- From: Hans Zeller [mailto:

RE: Set_SqlParser_Flags

2016-05-19 Thread Selva Govindarajan
A better technique would be to construct a class Class SqlParserFlags { ULng32 flagbits_; SqlParserFlags(ULng32 flagbits) { flagbits_ = flagbits; SqlParser_Flags |= flagbits; } ~SqlParserFlags() { SqlParser_Flags &= ~flagbits_ } } In the function where you want to se

RE: Trafodion master Daily Test Result - 211 - Failure

2016-05-19 Thread Selva Govindarajan
It looks like executor/TEST002 failed due to no space in swap. Error shown in the diff is > *** ERROR[8427] Hash Join Scratch IO Error occurred. Scratch > Error: -10005, System Error: 28, System Error Detail: 0, Details: > SQScratchFile::SQScratchFile(5) 4178c3135 System Error 28 is #define

RE: [VOTE] Apache Trafodion release 2.0.0 - release candidate 3

2016-05-19 Thread Selva Govindarajan
+1 Follow the instructions to setting up build environment in an existing centOS 6 VM of previous release. These instructions worked fine. I have made mistakes and encountered some hiccups on the way, but they were minor. 1. The VM I used already had /opt/home/tools directory with write permissi

RE: Trafodion master Daily Test Result - 212 - Still Failing

2016-05-20 Thread Selva Govindarajan
Hi Steve, Do we save .hprof files from logs directory currently? The hive tests failed due to out of memory to allocate java objects. Trafodion dumps the java objects heap when the JVM hits out of memory error. Selva -Original Message- From: steve.var...@esgyn.com [mailto:steve.var...@e

RE: Trafodion master Daily Test Result - 215 - Still Failing

2016-05-23 Thread Selva Govindarajan
The hprof with 0 bytes is now archived. Is there a way to get this hprof file to analyze the Java objects created. Selva -Original Message- From: steve.var...@esgyn.com [mailto:steve.var...@esgyn.com] Sent: Monday, May 23, 2016 4:43 AM To: dev@trafodion.incubator.apache.org Subject: Trafo

RE: Features for the next Trafodion release (R2.1)

2016-05-26 Thread Selva Govindarajan
I am planning to deliver ampool changes in a week or two. Ampool needs Java 1.8. I have been running with Java 8 in my private workspace for quite some time. Amanda said install would toggle between java 7 and java 8 based on what the product needs. It reads this info using a configuration file.

RE: Trafodion master Daily Test Result - 219 - Still Failing

2016-05-27 Thread Selva Govindarajan
Possible. It also could have been masked by out of memory in java objects heap space. But, what is not clear why is the expected file change needed in master and not in release 2.0. Selva -Original Message- From: Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] Sent: Friday, May

RE: discuss on support hbase 1.1

2016-06-15 Thread Selva Govindarajan
Another option is to check the code where Trafodion issues different APIs and rework so that common set of API can be used. Reflection concept in java might also work in some cases. If the rework is not possible then it might be necessary to stick with higher version. Selva -Original Message-

RE: discuss on support hbase 1.1

2016-06-20 Thread Selva Govindarajan
.1 public class CleanOldTransactionsChore extends ScheduledChore { #else public class CleanOldTransactionsChore extends Chore { #endif And there still some kind of changes I can hardly use reflection... -邮件原件----- 发件人: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] 发送时间: 2016年6月15日

RE: discuss on support hbase 1.1

2016-06-21 Thread Selva Govindarajan
No more trx files will be added. Have to use install_features to decide whice hbase version will be used.(discussed in the previous msg) -邮件原件- 发件人: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] 发送时间: 2016年6月21日 12:51 收件人: dev@trafodion.incubator.apache.org 主题: RE: discuss on supp

RE: FYI - Trafodion check tests are failing

2016-07-08 Thread Selva Govindarajan
Though PR 584 took care of the check PR issues, it could have introduced some issues for ODBC 3.0 application. A follow up JIRA https://issues.apache.org/jira/browse/TRAFODION-2100 has been created to take care of the new issue. See https://github.com/apache/incubator-trafodion/pull/584 for detail

Merging to Trafodion master - A tip

2016-07-08 Thread Selva Govindarajan
While merging the change to master involving multiple commits for a pull request (PR) I think it would be better to use --squash option. Most often multiple commits are made to address the review comments. Squashing these multiple commits into one eases the process of cherry picking the change to a

Proposal to add hive regression tests to check-PR tests

2016-07-15 Thread Selva Govindarajan
If you have subscribed to Trafodion Daily Build, you would have noticed that the daily build has been failing for some days. Most often, it is due the failure in hive regression tests run as part of the daily build. Lately, there has been some conscious effort made successfully to ensure that the h

RE: Proposal to add hive regression tests to check-PR tests

2016-07-18 Thread Selva Govindarajan
will it take for Hive regression? Br, Seth -Original Message- From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] Sent: 2016年7月16日 9:16 To: dev@trafodion.incubator.apache.org Subject: RE: Proposal to add hive regression tests to check-PR tests +1 to this -Original Message- From:

RE: Proposal to add hive regression tests to check-PR tests

2016-07-18 Thread Selva Govindarajan
basis. > > > My concern is that long running tests like hive/TEST018 are more to > > test > > > features like bulkload/unload and since we already have the option to > > > run "extra tests" in Jenkins, I'm not sure bringing in entire test > >

RE: Squash commits -

2016-07-21 Thread Selva Govindarajan
RE: Squash commits - I have attempted -squash earlier. But, didn't note down its implication earlier. I tried again as follows with recent merge successfully with squash option. You can omit the -m option too. The author name is retained by using reuse-message option of commit. I used the first

RE: Proposal to add hive regression tests to check-PR tests

2016-07-26 Thread Selva Govindarajan
;m willing to add another test job if that is what the community wants, but might it make more sense to more small tests to core or move some from hive to core? --Steve > -Original Message- > From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] > Sent: Monday

RE: Proposal to add hive regression tests to check-PR tests

2016-07-27 Thread Selva Govindarajan
TEST15 5 > > TEST17 5 > > TEST18 6 > > TEST21 1 > > TEST30 1 > > TEST31 1 > > TEST33 4 > > TEST34 2 > > TEST35 3 > > TEST36 1 > > > > The total time used is about 46 minutes. > > > > My vote will be to include a sub

RE: Trafodion master Daily Test Result - 289 - Failure

2016-08-03 Thread Selva Govindarajan
The failures in CompGeneral/TEST001, CompGeneral/TEST042 executor/TEST022 and hive/TEST004 are new. It is not clear if these failures are caused by or exposed by the changes in this build. How can we resolve these issues? Selva -Original Message- From: steve.var...@esgyn.com [mailto:ste

RE: Load with log error rows gets Trafodion not work

2016-09-08 Thread Selva Govindarajan
Hi Qiao, The JIRA you mentioned in the message is already fixed and merged to Trafodion on July 20th. It is unfortunate that this JIRA wasn’t marked as resolved. I have marked it as resolved now. This JIRA deals with the issue of trafodion process aborting when there is an error while logging t

[DISCUSS] Introducing Trafodion customization using its own configuration file.

2016-10-21 Thread Selva Govindarajan
Currently Trafodion uses the standard client side Hbase configuration file hbase-site.xml deployed by the distros. It is found that there are variations in this configuration file between distros. At times, the distro manager decides that a given property is not a client property and it is not a

RE: [DISCUSS] Introducing Trafodion customization using its own configuration file.

2016-10-21 Thread Selva Govindarajan
From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Friday, October 21, 2016 6:15 PM To: dev@trafodion.incubator.apache.org Subject: [DISCUSS] Introducing Trafodion customization using its own configuration file. Currently Trafodion uses the standard client side Hbase configuration

RE: [DISCUSS] Introducing Trafodion customization using its own configuration file.

2016-10-22 Thread Selva Govindarajan
older? Thanks, Eason On 22/10/2016, 10:16, "Selva Govindarajan" wrote: The properties added by the resource traf-site.xml will override the previously added resources, unless it was marked as final. Selva -Original Message- From: Sean Broeder [mail

RE: [DISCUSS] Introducing Trafodion customization using its own configuration file.

2016-10-24 Thread Selva Govindarajan
.@esgyn.cn] Sent: Sunday, October 23, 2016 5:14 AM To: dev@trafodion.incubator.apache.org Subject: RE: [DISCUSS] Introducing Trafodion customization using its own configuration file. I like this proposal very much. +1 Ming -Original Message----- From: Selva Govindarajan [mailto:selva

RE: [DISCUSS] Introducing Trafodion customization using its own configuration file.

2016-10-24 Thread Selva Govindarajan
t; Thanks, > > Hans > > -Original Message- > From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] > Sent: Sunday, October 23, 2016 5:14 AM > To: dev@trafodion.incubator.apache.org > Subject: RE: [DISCUSS] Introducing Trafodion customization using its

RE: [DISCUSS] Loading coprocessors from the client side dynamically

2016-10-24 Thread Selva Govindarajan
The coprocessors are neither pushed nor loaded dynamically from the SQL client side. They are simply added as the table attribute and hence configured as table coprocessor at the time of creation via Trafodion. So, if you do describe in hbase shell, you will see something like below describe 'T

RE: [DISCUSS] Loading coprocessors from the client side dynamically

2016-10-25 Thread Selva Govindarajan
this might work. I think you'd want to lock the database to prevent transactions during this time. Am I understanding your proposal correctly? Thanks, Sean -Original Message- From: Selva Govindarajan [mailto:selva.govindara...@esgyn.com] Sent: Monday, October 24, 2016 10:37 PM T

  1   2   >