RE: Is varchar(300 bytes) character set utf8 better than varchar(100 chars) character set utf8?

2017-12-06 Thread Hans Zeller
Hi, Yes, I would say that "varchar(300 bytes) character set utf8" is preferable over "varchar(100 chars) character set utf8". Two reasons: First, the former can store more information, you can fit 300 ASCII characters while the second can fit only 100. Second, Trafodion actually assumes a

RE: trafodion question

2017-12-04 Thread Hans Zeller
Hi, This also happened to me recently when upgrading from one development version of Trafodion to the next. I also thought that it had to do with memory, but couldn't find any messages that pointed to the OOM (out-of-memory) killer. I then started over with a new, clean source tree and a new

RE: trafodion question

2017-12-04 Thread Hans Zeller
Hi, It looks like MySQL does not allow this kind of syntax in its configuration file. Maybe removing the curly braces might work. Another option is to remove the backslash in this line in file core/sqf/sql/scripts/install_local_hadoop:

RE: Upcoming Incubator Report (dec 2017)

2017-11-20 Thread Hans Zeller
Hi, Sure, I can provide those numbers at the end of the month. Here is how I usually determine them: git log --after=2017-09-01 --oneline | grep -v ' Merge ' | wc -l git log --after=2017-09-01 --summary | grep Author: | sort | uniq -c JIRA search: project = TRAFODION and createdDate >

Re: [VOTE] Graduate from Incubator and become a top-level project

2017-11-17 Thread Hans Zeller
+1 Hans On Nov 16, 2017, at 5:22 PM, Pierre Smits > wrote: This vote will run at least the obligatory (and minimum) number of hours: 72 hrs. Best regards, Pierre Smits ORRTIZ.COM OFBiz based

RE: [VOTE] Apache Trafodion release 2.2.0 - release candidate 1

2017-10-17 Thread Hans Zeller
+1 Things I tried: Downloaded source tar on an Amazon CentOS 6 instance (m4.2xlarge). Followed instructions from https://cwiki.apache.org/confluence/display/TRAFODION/Create+Build+Environment Built Trafodion from source code Tried to run it, using the install_local_hadoop script, but ran out of

RE: Change default varchar(n) character set utf8 to varchar(n bytes) character set utf8?

2017-09-19 Thread Hans Zeller
Hi Yuan, This feature already exists, I think. You can set the following: cqd TRAF_COL_LENGTH_IS_CHAR 'OFF'; and that should make n BYTES the default behavior. I only did a quick test, and it seems to work. You can set this in the system defaults table to make it the default for the entire

RE: [VOTE][round 3]Release Apache Trafodion JDBC T4 driver 2.2.0 to Maven Central Repository

2017-09-11 Thread Hans Zeller
+1 Downloaded the zip file and tried a simple connection using SQuirreL on my Windows machine. Hans -Original Message- From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] Sent: Monday, September 11, 2017 4:36 PM To: dev@trafodion.incubator.apache.org Subject: RE: [VOTE][round 3]Release

RE: Podling Report Reminder - September 2017

2017-09-05 Thread Hans Zeller
FYI, our report is posted now at the wiki, https://wiki.apache.org/incubator/September2017. -Original Message- From: johndam...@apache.org [mailto:johndam...@apache.org] Sent: Tuesday, September 5, 2017 6:41 PM To: dev@trafodion.incubator.apache.org Subject: Podling Report Reminder -

RE: Podling Report Reminder - September 2017

2017-09-05 Thread Hans Zeller
> <dave.birds...@esgyn.com> > wrote: > >> Looks good, Hans. >> >> -Original Message- >> From: Hans Zeller [mailto:hans.zel...@esgyn.com] >> Sent: Tuesday, September 5, 2017 10:20 AM >> To: dev@trafodion.incubator.apache.org >> Subject

RE: Podling Report Reminder - September 2017

2017-09-05 Thread Hans Zeller
Stack Comments: IPMC/Shepherd notes: -Original Message- From: Hans Zeller [mailto:hans.zel...@esgyn.com] Sent: Tuesday, September 5, 2017 9:11 AM To: dev@trafodion.incubator.apache.org Subject: RE: Podling Report Reminder - September 2017 I can do the report. Hope to send out

RE: Podling Report Reminder - September 2017

2017-09-05 Thread Hans Zeller
I can do the report. Hope to send out a draft version later today. Hans -Original Message- From: johndam...@apache.org [mailto:johndam...@apache.org] Sent: Monday, September 4, 2017 4:43 PM To: dev@trafodion.incubator.apache.org Subject: Podling Report Reminder - September 2017 Dear

RE: trafci doesn't work

2017-08-29 Thread Hans Zeller
Hi Bin, Thanks for letting us know! If this happens again, let us know if we can help diagnosing the problem. One potential reason might be that the system is running out of memory. Hans -Original Message- From: Bin Lin [mailto:linbi...@gmail.com] Sent: Tuesday, August 29, 2017 5:34

RE: trafci doesn't work

2017-08-29 Thread Hans Zeller
Hi Bin, you can try the following command: sqcheck If this shows any services that are "down", then do the following: sqstop sqstart In case the sqstop command hangs for more than two minutes, kill it with CTRL-C and run the following command before sqstart: ckillall Let us know whether

RE: default database port on developer build?

2017-07-26 Thread Hans Zeller
Hi Eric, if you use the install_local_hadoop script, take a look at these two files: $TRAF_HOME/sql/scripts/sw_env.sh $TRAF_HOME/sql/scripts/swurls.html I bookmark the HTML file in my browser, so I can easily reach the DCS and HBase web GUIs. Hans -Original Message- From: Eric Owhadi

RE: [R2.2 Release] create branch

2017-07-13 Thread Hans Zeller
Hi Ming, sounds good. It might be good to get TRAFODION-2628 into the release as well. See https://github.com/apache/incubator-trafodion/pull/1170. Thanks, Hans -Original Message- From: Liu, Ming (Ming) [mailto:ming@esgyn.cn] Sent: Thursday, July 13, 2017 7:54 PM To:

RE: Trafodion master rh6 Daily Test Result - 101 - Failure

2017-06-08 Thread Hans Zeller
master rh6 Jenkins Job: https://jenkins.esgyn.com/job/Check-Daily-master-rh6/101/ Archived Logs: http://traf-testlogs.esgyn.com/Daily-master/101 Bld Downloads: http://traf-builds.esgyn.com Changes since previous daily build: [Hans Zeller] [TRAFODION-2636] Memory leak in metadata context Test

RE: Report Mar-Apr-May (June 2017 report)

2017-06-05 Thread Hans Zeller
Hi, Yes, sorry, my mistake for omitting that from the last report. The report looks good to me. Here are the numbers you asked for, Pierre: # number of commits since March git log --after=2017-03-01 --oneline | grep -v ' Merge ' | wc -l 191 # number of contributors git log --after=2017-03-01

RE: Update statistics and metadata tables

2017-05-31 Thread Hans Zeller
+1 Hans -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Tuesday, May 30, 2017 3:14 PM To: dev@trafodion.incubator.apache.org Subject: RE: Update statistics and metadata tables I don't think the code can use statistics on metadata tables. At least not as

RE: Podling Report Reminder - June 2017

2017-05-23 Thread Hans Zeller
Yes, Pierre volunteered a few days ago. -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Tuesday, May 23, 2017 8:06 AM To: dev@trafodion.incubator.apache.org Subject: RE: Podling Report Reminder - June 2017 Hi, Any volunteers to do the report this month?

RE: [RELEASE PLANING] 2.2 Release Management

2017-05-22 Thread Hans Zeller
Hi Ming, I updated the status of two JIRAs that are currently assigned to me. Those may not be good candidates for R2.2, as I don't have plans to work on them. Unless someone else wants to volunteer to take them, I would suggest we remove them from the list of planned JIRAs. Thanks, Hans

Release manager for our next Trafodion release - any volunteers?

2017-05-08 Thread Hans Zeller
Hi, Sandhya did a wonderful job getting Trafodion 2.1.0-incubating released, thank you for all your work!! Just wanted to start a discussion on who might be willing to be the Release Manager for our next release, may that be 2.2.0 or a smaller patch. If you are wondering what you would have

RE: New Apache Incubator logo

2017-04-17 Thread Hans Zeller
Hi Dave, I can give it a try. Hope to have the site updated soon. Hans -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Monday, April 17, 2017 8:38 AM To: dev@trafodion.incubator.apache.org Subject: New Apache Incubator logo Hi Trafodionites, Some of you

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

2017-04-12 Thread Hans Zeller
+1 Verified signature and followed instructions (see original email below) for building from source on a single-node Amazon AWS t2.xlarge instance, running CentOS 6 (https://aws.amazon.com/marketplace/pp/B00NQAYLWO). This went without any problems, the instructions are very good! Hans

RE: Website updates /documentation changes for Trafodion 2.1 and 2.2

2017-03-27 Thread Hans Zeller
t. Thank you Sandhya -Original Message----- From: Hans Zeller [mailto:hans.zel...@esgyn.com] Sent: Tuesday, March 7, 2017 6:04 PM To: dev@trafodion.incubator.apache.org Subject: Documentation changes for Trafodion 2.1 and 2.2 Hi, Since Sandhya has split off the release branch for Tra

RE: Could someone remind me of the port number to use for hbase-status when using local_hadoop?

2017-03-14 Thread Hans Zeller
Hi Dave, The file is $TRAF_HOME/sql/scripts/swurls.html I have that file bookmarked in the browser that I run on my workstation. Hans -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Tuesday, March 14, 2017 11:00 AM To: dev@trafodion.incubator.apache.org

RE: Followers + Likes + Tweets

2017-03-08 Thread Hans Zeller
- > Email:carol.pearson...@gmail.com > Twitter: @CarolP222 > ------- > > On Mon, Mar 6, 2017 at 8:14 AM, Hans Zeller <hans.zel...@esgyn.com> wrote: > > > Hi Pierr

Documentation changes for Trafodion 2.1 and 2.2

2017-03-07 Thread Hans Zeller
Hi, Since Sandhya has split off the release branch for Trafodion 2.1, documentation changes that are meant for 2.1 should be checked into that release. You can add documentation for 2.2 features to the main branch. As far as I remember, this is the simple approach agreed to by Steve and Gunnar

RE: Followers + Likes + Tweets

2017-03-06 Thread Hans Zeller
Hi Pierre, That sounds good in principle, but I checked several sites of other Apache projects and couldn't find any that have links for social media. Does anyone see a good example of an Apache project site we could follow? Thanks, Hans -Original Message- From: Pierre Smits

RE: Draft podling report for March

2017-03-01 Thread Hans Zeller
of follower on twitter (217 per today). 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, Feb 28, 2017 at 6:33 PM, Hans Zeller <hans.zel...@esgyn.com> wrote: > Hi Pie

Draft podling report for March

2017-02-27 Thread Hans Zeller
Hi, Here is the draft quarterly report. Please let me know if you have any comments, corrections, additions, for example if you talked about Trafodion in some public event and would like your talk included. I especially want to direct your attention to two items in the report (highlighted in

RE: Podling Report Reminder - March 2017

2017-02-26 Thread Hans Zeller
Hi, hope to send out a draft report on Monday, unless someone else is already working on it. Hans -Original Message- From: johndam...@apache.org [mailto:johndam...@apache.org] Sent: Saturday, February 25, 2017 3:50 PM To: dev@trafodion.incubator.apache.org Subject: Podling Report

RE: [DISCUSSION] Work towards graduation

2017-02-21 Thread Hans Zeller
Hi, Just wanted to comment on one thing in the email below: Stack, you call yourself a "deadbeat mentor". I want to disagree strongly with that and say thank you for the many things you are continuously doing, from granting Karma to making connections to other projects to asking the right

RE: Podling Report Reminder - December 2016

2016-12-05 Thread Hans Zeller
The draft report is now up on the Apache wiki: https://wiki.apache.org/incubator/December2016 Let me know if you have any comments or suggestions, we have two more days to make corrections. Thanks, Hans -Original Message- From: johndam...@apache.org [mailto:johndam...@apache.org]

RE: Podling Report for December 2016 - first draft

2016-11-30 Thread Hans Zeller
Hi, Here is a first draft of our quarterly report. Could you please take a look and let me know of errors or omissions? Did anyone give a talk on Trafodion during the last 3 months that we could list? Trafodion Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or

RE: Podling Report Reminder - December 2016

2016-11-28 Thread Hans Zeller
I'll do it. Hope to have a draft ready later this week. -Original Message- From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Monday, November 28, 2016 1:26 PM To: dev@trafodion.incubator.apache.org Subject: FW: Podling Report Reminder - December 2016 Anyone picking this up for

RE: Is it good idea to add VARCHAR2 as an alias for VARCHAR?

2016-10-27 Thread Hans Zeller
Hi, The properties of Oracle VARCHAR, that it stores an empty string as NULL, is not really a desirable feature, I think, it's somewhere between a bug and a "feature". I hope we won't have to spend effort to simulate this "feature"? Just mapping VARCHAR2 to VARCHAR sounds like a good solution

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

2016-10-24 Thread Hans Zeller
Hi, Sounds good to me, too. I wonder, however, whether we shouldn't prepend "trafodion" to the properties in the file. So, instead of hbase.client.scanner.timeout.period, for example, what about calling it trafodion.hbase.client.scanner.timeout.period. This should avoid confusion. Thanks,

[MENTORS] Podling report mentor signoff due today

2016-09-13 Thread Hans Zeller
Hi, Just a gentle reminder that the mentor sign-off is due today. http://wiki.apache.org/incubator/September2016 Thanks, Hans -- Forwarded message -- From: Marvin Humphrey Date: Mon, Sep 12, 2016 at 1:56 PM Subject: DRAFT report September 2016 To:

Re: Podling Report Reminder - September 2016

2016-09-01 Thread Hans Zeller
https://cwiki.apache.org/confluence/display/TRAFODION/Roadmap > > In section "How has the community developed since the last report?" > > * Esgyn Corp hosted a Trafodion Meetup on August 5th > > Regards, > Atanu > > -Original Message-

Re: Podling Report Reminder - September 2016

2016-08-31 Thread Hans Zeller
Hi, Here is a draft podling report, please let me know if you have comments. I will post the corrected version on the website tomorrow (we can still make changes 'til Wed). Trafodion Trafodion is a webscale SQL-on-Hadoop solution enabling transactional or operational workloads on Hadoop.

Re: Log files for SQL processes in Trafodion

2016-08-22 Thread Hans Zeller
Hi Dave, The easiest solution may be to use the event_log_reader function to find that information. Maybe the upgrade operation could ask the user to run a query like this: select message from udf(event_log_reader('f')) where log_file_name = 'some filename' /* and maybe some other

[ANNOUNCE] New Trafodion PPMC member: Steve Varnau

2016-08-18 Thread Hans Zeller
The Podling Project Management Committee (PPMC) for Apache Trafodion has asked Steve Varnau, who already is a committer, to join the PPMC. We are pleased to announce that he has accepted. Steve has been very instrumental from the start in our build and test environment, defining and implementing

Re: Working towards graduation

2016-07-28 Thread Hans Zeller
Hi Pierre, thank you for bringing this up. I agree that we need to consider new things to do to increase our diversity. You are familiar with the Apache community, do you have any observations or suggestions? When I look at the just-graduated Apache Kudu, I see that it also lacks diversity, but

Re: Squash commits

2016-07-18 Thread Hans Zeller
Hi, Sorry to chime in late. I would like to propose that we do NOT squash the commits in a PR. Instead, we could ask contributors to squash, if their changes consist of too many commits. Here are my reasons: 1. Squashing the commits takes away the contributor's commit and makes it looks

Re: add a roadmap page in Trafodion's project page

2016-07-14 Thread Hans Zeller
+1, and with it we probably need to have an idea on how to populate the roadmap page. I could imagine a page with three sections, something along the lines of Kafka or Hive

Re: Trafodion Clutch Report

2016-07-05 Thread Hans Zeller
For those podlings with a positive number of committers in column J of the clutch report there is a link, for example http://people.apache.org/committers-by-project.html#tephra for Tephra. I think that gives us a good idea where our problem is - with a

[ANNOUNCE] New Committer and PPMC member: Gunnar Tapper

2016-07-05 Thread Hans Zeller
The Podling Project Management Committee (PPMC) for Apache Trafodion has asked Gunnar Tapper to become a committer and PPMC member. We are pleased to announce that he has accepted and that the necessary karma has been granted. Gunnar has contributed to Trafodion from the beginning of the project.

Re: [VOTE] Release Apache Trafodion 2.0.1-incubating RC1

2016-06-07 Thread Hans Zeller
+1 Downloaded client package and did a quick validation (using ldd and nm) that it loads with the libssl and liblber DLLs and that things like RSA_private_decrypt, RSA_public_encrypt are not part of the artifact. Hans On Tue, Jun 7, 2016 at 11:34 AM, Steve Varnau wrote:

Re: Podling Report Reminder - June 2016

2016-05-31 Thread Hans Zeller
0.0 is about to go out so worth mention too... > > > > Otherwise, report is great. > > > > Do we want to go get some new mentors? The set you have -- I include > myself > > -- participate little. If so, might want to mention in report ... or > not... >

Re: Podling Report Reminder - June 2016

2016-05-31 Thread Hans Zeller
Yes, thanks, Suresh, I hope to have a draft report ready in a few hours. Hans On Mon, May 30, 2016 at 8:04 PM, Suresh Subbiah wrote: > Thank you Dave, will do. > > Suresh > > On Mon, May 30, 2016 at 3:19 PM, Dave Birdsall > wrote: > > > Hi

Re: How the manuals are built for back releases

2016-05-26 Thread Hans Zeller
pdate stats and create indexes on> > > > > ------- > > Email:carol.pearson...@gmail.com > > Twitter: @CarolP222 > > --- > > > > On Thu, May 26, 2016 at 11:45 AM, Hans Zel

Re: How the manuals are built for back releases

2016-05-26 Thread Hans Zeller
process was designed to create manuals in a release-specific > folder, so it is quite possible to build 2.0, switch branches, build 2.1, > etc. Then copy the results over to the -site repo where they are published > to the web. > > --Steve > > > > -Original Message- &

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

2016-05-26 Thread Hans Zeller
Can we throw in support for RHEL/CentOS 7 (TRAFODION-1861 ) as well? It looks like Eason is making good progress with this. Hans On Thu, May 26, 2016 at 8:19 AM, Dave Birdsall wrote: > Sounds good to me. > >

Re: Pony UI client for apache e-mail lists

2016-05-24 Thread Hans Zeller
Thanks, looks very nice! Hans On Fri, May 20, 2016 at 3:47 PM, Dave Birdsall wrote: > Hi, > > > > There is a new web-based UI called Pony that has been put forward for > browsing apache e-mail archives. If you’d like to try it against the > Trafodion dev list, here’s

Re: Set_SqlParser_Flags

2016-05-19 Thread Hans Zeller
+1 it would be good to move (more or less gradually) to the new methods that are easier to understand. Hans On Wed, May 18, 2016 at 3:55 PM, Dave Birdsall wrote: > Hi, > > I'm concerned that these bugs propagate to some extent by code cloning. For > that, documentation

Re: 2.0 release candidate

2016-05-04 Thread Hans Zeller
Hi again, Actually, never mind TRAFODION-1964 , Venkat and I found more issues with this and decided that we can't fix this easily for 2.0. Hans On Wed, May 4, 2016 at 10:26 AM, Steve Varnau wrote: > The daily test

Re: 2.0 release candidate

2016-05-04 Thread Hans Zeller
Hi Steve, Could you give us one more day to get a fix for TRAFODION-1964 in? Hopefully I'll submit a pull request later today. Thanks, Hans On Wed, May 4, 2016 at 10:12 AM, Gunnar Tapper wrote: > Shouldn't the

Re: Using Eclipse to debug Trafodion Java code

2016-04-22 Thread Hans Zeller
sgyn.com> wrote: > > > 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 >

Re: Non deteminism in tests (Trafodion master Daily Test Result - 165)

2016-04-04 Thread Hans Zeller
a comment? Why not open it up > to > anyone? > > Sean > > -Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Monday, April 4, 2016 1:09 PM > To: dev <dev@trafodion.incubator.apache.org> > Subject: Re: Non deteminism in tests (Trafo

Re: Non deteminism in tests (Trafodion master Daily Test Result - 165)

2016-04-04 Thread Hans Zeller
combined. Unless we automate this full regression > testing , whatever Han's lists below will continue to be a problem. (Do we > have the test machine resources to do this ?) > > 2. The other option is for Trafodion committers to NOT commit/merge the PR > until the results of the entire SQL

Re: Trafodion master Daily Test Result - 165

2016-04-04 Thread Hans Zeller
Don't know about you, but seeing tests fail every single day makes me kind of indifferent to these test failures, after a few hundred of them... I really wish we could have an environment where the daily email we get is at least 8 out of 10 times a clear indicator whether a build is good or not.

Re: 答复: new requirments for Trafodion to be more tolerate during bulkloading

2016-03-31 Thread Hans Zeller
RDBMS do this. Will update later, for now, we can ignore this requirement. > > Thanks, > Ming > > -邮件原件-'hhh > 发件人: Hans Zeller [mailto:hans.zel...@esgyn.com] > 发送时间: 2016年3月31日 1:49 > 收件人: dev <dev@trafodion.incubator.apache.org> > 主题: Re: new requirments f

Re: new requirments for Trafodion to be more tolerate during bulkloading

2016-03-30 Thread Hans Zeller
Hi Ming, Yes, it would be good if Trafodion would behave in ways similar to Hive. It would also be good if errors in the data wouldn't make the entire bulk load fail. Instead, those error rows should ideally go into a separate file or table (with additional fields for source file name and line

Re: [DISCUSSION] Time to graduate

2016-03-29 Thread Hans Zeller
Hi, Agree with Stack's list of issues. As far as I understand, the next release will include a binary distribution and will no longer require third party vendor distributions (Cloudera or Hortonworks). It will of course still support those. Hans On Tue, Mar 29, 2016 at 8:59 AM, Carol Pearson

Re: How to get date from sqlci in binary format

2016-03-24 Thread Hans Zeller
value of the item. > Now , JDBC T2 will get a string format datetime through this function . > What I want to do is getting the binary datetime from this function. Do you > have any idea? > > Best Regards, > Weiqing > > On Thu, Mar 24, 2016 at 2:35 PM, Hans Zeller <ha

Re: How to get date from sqlci in binary format

2016-03-24 Thread Hans Zeller
Hi Weiqing, Here is a code fragment from the UDF code that converts a string to the Java "Date" type, taken from https://github.com/apache/incubator-trafodion/blob/master/core/sql/src/main/java/org/trafodion/sql/udr/TupleInfo.java Date resultDate; String val =

Re: Character set for hive table columns?

2016-03-10 Thread Hans Zeller
Hi Dave, this is determined by CQD HIVE_DEFAULT_CHARSET (hard-wired default is UTF8). Ming recently introduced a second CQD, HIVE_FILE_CHARSET. That allows to have GBK data in an HDFS file and have the Hive table produce UTF-8 characters (set HIVE_FILE_CHARSET to GBK and HIVE_DEFAULT_CHARSET to

Re: Test Environment: What Limits Matter?

2016-03-10 Thread Hans Zeller
Somebody, in their infinite wisdom, introduced another file that overrides the nproc limit set in /etc/security/limits.conf, see https://bugzilla.redhat.com/show_bug.cgi?id=919793. The solution is probably to delete file /etc/security/limits.d/90-nproc.conf. Hans On Thu, Mar 10, 2016 at 9:38 AM,

Re: 答复: Pre Build Development Tools for Download

2016-03-07 Thread Hans Zeller
Hi, The biggest issue I see with this is that some of the tools hard-code the tool's location in the built code. I found that I could not move the tools tree once it was built, since many shell scripts referred back to the original location. One of the tools having this issue is Bison (see

Re: UDR/TEST002

2016-03-07 Thread Hans Zeller
Hope you solved the problem over the weekend. Arvind found the bug and suggested a solution, see https://github.com/apache/incubator-trafodion/pull/369. Hans On Fri, Mar 4, 2016 at 2:47 PM, Hans Zeller <hans.zel...@esgyn.com> wrote: > Hi Eric, my guess would be that you ne

Re: UDR/TEST002

2016-03-04 Thread Hans Zeller
Hi Eric, my guess would be that you need to run install_traf_components after doing the install_local_hadoop and building the source. DCS is probably not up. You can check with sqcheck. I would try this, if it actually turns out that DCS is not running: sqstop install_traf_components sqstart

Re: FW: March 2016 Incubator report timeline

2016-02-29 Thread Hans Zeller
ichael Stack Shepherd/Mentor notes: Thanks, Hans On Thu, Feb 25, 2016 at 4:13 PM, Amanda Moran <amanda.mo...@esgyn.com> wrote: > HI there- > > Andrew Purtell resigned as a mentor as well. > > Thanks. > > On Thu, Feb 25, 2016 at 4:10 PM, Hans Zeller <hans.zel..

Re: March 2016 Incubator report timeline

2016-02-26 Thread Hans Zeller
on <roberta.mar...@esgyn.com> 写道: > > I am sorry, I thought he was publically announced. Did I miss sending out a > message? > >Roberta > > -Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Thursday, February 25, 2016 4:54 PM

Re: FW: March 2016 Incubator report timeline

2016-02-25 Thread Hans Zeller
mar...@esgyn.com> wrote: > We have a new committer - RuoYu Zuo > (I have been lapse in updating the projects page - will do it now.) > >Roberta Marton > -Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Thursday, February 25,

Re: FW: March 2016 Incubator report timeline

2016-02-25 Thread Hans Zeller
Thanks, Hans On Thu, Feb 25, 2016 at 11:52 AM, Hans Zeller <hans.zel...@esgyn.com> wrote: > Hi, > > Sure, I can take a stab at that. > > Hans > > On Thu, Feb 25, 2016 at 11:07 AM, Dave Birdsall <dave.birds...@esgyn.com> > wrote: > >> Hi Trafodionites,

Re: FW: March 2016 Incubator report timeline

2016-02-25 Thread Hans Zeller
Hi, Sure, I can take a stab at that. Hans On Thu, Feb 25, 2016 at 11:07 AM, Dave Birdsall wrote: > Hi Trafodionites, > > Do we have a volunteer to prepare the podling report for Trafodion? It > should cover the last three months. > > Dave > > -Original

Re: [DISCUSS] Change the default setting of ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT to ON

2016-02-03 Thread Hans Zeller
Just a comment on what the "uniqueness constraint" means: In Trafodion, two rows (1, NULL) and (1, NULL) are considered duplicates and are rejected. That's probably ok and what many (most?) people mean. However, the SQL standard defines uniqueness with nullable columns differently, any row with a

Re: Contributor Guide Ported to Wiki

2016-01-27 Thread Hans Zeller
Thanks, Gunnar, that looks great and I hope we will all help to maintain it. The organization into more or less chronological individual steps works well for me. One comment: There are sections 15 and 16 that talk about merging changes and building a release. Those are for committers, not

Re: Test hanging

2016-01-26 Thread Hans Zeller
hanging > > > > > > Thanks Hans, > > > I'm trying a suggestion to add a property to the mapred-site.xml file > - … > > > > > > mapreduce.framework.name > > > local == from yarn to local > > >

Re: New Version of Contributor Guide Uploaded

2016-01-26 Thread Hans Zeller
Hi Gunnar, Looks really nice overall! Here are a few comments: - 4.3.3 "Create Pull Request": This shows "git pull-request" to create a pull request. It should also mention that you can do this on the web by going to https://github.com/apache/incubator-trafodion and pressing the

Re: Error injection?

2016-01-22 Thread Hans Zeller
Hi Dave, as far as I remember, Mike Hanlon implemented "cancel injection" in the executor many years ago, this allows us to randomly cancel queries at randomly chosen points. He may also have added a feature to inject errors in the IPC layer. I don't remember details of that and am not even sure

Re: Apache Trafodion release

2016-01-20 Thread Hans Zeller
Wonderful job, Roberta. Thank you very much for all the work that went into this! How much arm-twisting would it take to get you to volunteer for a second term? You set all the ground work, thanks to your work the second release should be much easier for the Release Manager. Hans On Wed, Jan

Re: Apache Trafodion release

2016-01-20 Thread Hans Zeller
willing to take a turn as release manager if she > wants a break. > > --Steve > > > > -Original Message- > > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > > Sent: Wednesday, January 20, 2016 10:34 AM > > To: dev <dev@trafodion.i

Re: 2 last test failing for the pushdown V2 feature, is that just me?

2016-01-12 Thread Hans Zeller
Hi, I also see this failure involving the _HBASESTATS_ schema all the time. It only happens when you run the regression tests more than once, something we don't do on the official builds. This test needs to be fixed. Hans On Fri, Jan 8, 2016 at 8:26 AM, Sandhya Sundaresan <

Re: question on ValueIdSet::isNotNullable

2016-01-06 Thread Hans Zeller
both cases. And I have seen both > > cases too in my various testing. I have not tried to single out why > > that is and why one is picked vs the other... just assumed that I needed > > to account for both. > > Cheers, > > Eric > > On Jan 5, 2016 9:50 PM, "Hans Z

Re: question on ValueIdSet::isNotNullable

2016-01-06 Thread Hans Zeller
ull night, don t want to link > both... > Eric > > -----Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Wednesday, January 6, 2016 3:56 PM > To: dev <dev@trafodion.incubator.apache.org> > Subject: Re: question on ValueIdSet::isNotNul

Re: question on ValueIdSet::isNotNullable

2016-01-06 Thread Hans Zeller
timization, if the same issue is happening on other construct > I would not know... > Eric > > -Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Wednesday, January 6, 2016 11:24 AM > To: dev <dev@trafodion.incubator.apache.org> > Subje

Re: question on ValueIdSet::isNotNullable

2016-01-06 Thread Hans Zeller
a>0 OR (b=0 and c>0) that would end up parsed > recursively. > I will however revert my change and implement your, have you checked it in > master? Or should I just add it in as part of my checkin? > Eric > > > -Original Message- > From: Hans Zelle

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

2016-01-05 Thread Hans Zeller
; In the long run, I can add the charset GBK as one of the supported > > Trafodion column charset. Then we can use this feature in more cases, > > and we can support a column to be encoded as GBK which is also a nice > > feature. > > But in short term, I think the most desir

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

2016-01-05 Thread Hans Zeller
ld limit run-time support to a translate > operator; other expression operators would operate only on known character > sets). > > Dave > > -Original Message- > From: Hans Zeller [mailto:hans.zel...@esgyn.com] > Sent: Tuesday, January 5, 2016 9:21 AM > To: dev <de

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

2016-01-05 Thread Hans Zeller
then it is OK, no problem, the > problem is it will treat a not NUL char, which has '\0' in middle of its > encoding. For example, a multi-bye character is encoded as [ 0x00, 0xFB ], > that will be an issue for Trafodion, since the strcpy will truncate the > string at the first byte wro

Re: question on ValueIdSet::isNotNullable

2016-01-05 Thread Hans Zeller
Hi Eric, I think the reason this method does not consider AND is that a ValueIdSet should not contain any AND predicates, since the set itself assumes an ANDing of all of its members. So, instead of a single member AND(an>=20, an<=30), the ValueIdSet should contain two members: an>=20, an<=30, in

Re: enhance TRANSLATE to support Chinese charset?

2016-01-05 Thread Hans Zeller
est solution now, no need to change the > TRANSLATE function. > > Thanks, > Ming > > -邮件原件- > 发件人: Hans Zeller [mailto:hans.zel...@esgyn.com] > 发送时间: 2016年1月6日 11:32 > 收件人: dev <dev@trafodion.incubator.apache.org> > 主题: Re: 答复: 答复: 答复: enhance TRANSLATE

Re: question on ValueIdSet::isNotNullable

2016-01-05 Thread Hans Zeller
gt; > wrote: > > > HI Hans, unfortunately, that is not the case. Even the predicate push > down > > version 1 code take care of both cases. And I have seen both cases too in > > my various testing. I have not tried to single out why that is and why > one > > is

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

2016-01-05 Thread Hans Zeller
gt; > disabling creating trafodion tables with GBK character columns and GBK > > literals (both in the parser) is still reasonably sized. > > > > With this, Trafodion only recognizes GBK as a source charset for Hive > > tables, and is able to convert the GBK source

Re: enhance TRANSLATE to support Chinese charset?

2016-01-04 Thread Hans Zeller
Hi, Kevin's question make me think of another question: The TRANSLATE function takes a value a with character set ca and translates it into a new value b with character set cb. Since we don't support GBK as character sets in data types, I wonder how we could call this function. People may in some

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

2015-12-24 Thread Hans Zeller
cripts/sw_ > > env.sh > > to get the list of ports > > make[1]: *** [trafinstall] Error 1 > > make[1]: Leaving directory > > `/home/stack/apache-trafodion-1.3.0-incubating/core' > > make: *** [trafinstall] Error 2 > > > > ... which I suppose is generated. > >

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

2015-12-23 Thread Hans Zeller
: > > > Some of the prerequisites for building the software are mentioned in the > > following - libiodbc is one of them. Hope this helps. > > > > > https://cwiki.apache.org/confluence/display/TRAFODION/Building+the+Software > > > > > &

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

2015-12-23 Thread Hans Zeller
0: error: sqlext.h: No such file or directory > ##(NDCS) > make[3]: *** [Linux-x86_64/64/dbg/SQLWrapper.o] Error 1 ##(NDCS) > > > > St.Ack > > > On Wed, Dec 23, 2015 at 1:45 PM, Hans Zeller <hans.zel...@esgyn.com> > wrote: > > > Here is another option

  1   2   >