Re: Make "HBase options" as default setting?

[Carol Pearson]

I think we need to optimize for end users, not necessarily easier for
development environments.  End users the ones for whom we need to make
things easy so that their initial experience doesn't include a bunch of
extra switches to get reasonable performance.  So I'm +1 on the original
suggestion as well.

I think that if it's an issue for dev environments, we add it to a
trafodion developers environment customization script that developers can
run as needed.  But that's a discussion for the dev list, not user.

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Wed, Jun 7, 2017 at 9:51 AM, Rohit Jain  wrote:

> I am suggesting that we change the default settings to those as proposed
> so that all tables use those settings by default.  So, it is a +1.  A CQD
> might be used to override the default.  This, hopefully will be rare.  I
> just think that having entries in a system DEFAULTS table are problematic
> for the reasons I mentioned. Of course, they would be in the compiler’s
> default settings.
>
>
>
> Rohit
>
>
>
> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
> *Sent:* Wednesday, June 7, 2017 11:28 AM
>
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Make "HBase options" as default setting?
>
>
>
> So, would this make you a -1 on the original suggestion? (that is, just
> changing the HBASE_OPTIONS defaults?)
>
>
>
> *From:* Rohit Jain [mailto:rohit.j...@esgyn.com ]
> *Sent:* Wednesday, June 7, 2017 9:16 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Make "HBase options" as default setting?
>
>
>
> Dave,
>
>
>
> CQDs indicate that we might make a different decision on these for certain
> customers.  If that is not the case, then we are just increasing the
> complexity of configuring a system with the right default defaults, etc.
> and opening ourselves us for the possibility that something may go wrong.
> Often times, folks are not even aware as to what is set in the DEFAULTS
> table and are puzzled by the behavior, sometimes because someone added
> something to that table or changed the setting and forgot to set it back,
> etc.  Then you have to document these CQDs, when to change them, etc.  So,
> while the flexibility of having so many buttons may be a good thing to
> cover all possible theoretical combinations one might come up with, from a
> practical standpoint the KISS (Keep It Simple Stupid) principal trumps all.
>
>
>
> Rohit
>
>
>
> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com
> ]
> *Sent:* Wednesday, June 7, 2017 10:44 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Make "HBase options" as default setting?
>
>
>
> What might make sense is to add a CQD (or maybe a set of them) with
> default values for certain HBASE_OPTIONS settings. Then one could put these
> CQDs in the system DEFAULTS table. So, you’d set it once in a cluster
> installation and then not have to worry about it afterwards.
>
>
>
> *From:* Dave Birdsall
> *Sent:* Wednesday, June 7, 2017 8:26 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: Make "HBase options" as default setting?
>
>
>
> -1  Snappy is often not installed on workstations, so I would not want to
> make that the default.
>
>
>
> *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com ]
>
> *Sent:* Wednesday, June 7, 2017 4:52 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Make "HBase options" as default setting?
>
>
>
> +1
>
>
>
>
>
>
>
> Sent from my Samsung Galaxy smartphone.
>
>
>
>
>
>  Original message 
>
> From: "Liu, Yuan (Yuan)" 
>
> Date: 6/6/17 10:29 PM (GMT-06:00)
>
> To: user@trafodion.incubator.apache.org
>
> Subject: Make "HBase options" as default setting?
>
>
>
> Hi Trafodioners,
>
>
>
> As we know, for performance thinking, we always need to add below syntax
> in “create table” syntax. And I know in latest version, we have made 
> “ATTRIBUTES
> ALIGNED FORMAT” as default, do we have a plan that make
> HBASE_OPTIONS(including ENCODING、COMPRESSION、MEMESTORE) as the default
> setting when creating table? I think this will be easier for new users?
>
>
>
> ATTRIBUTES ALIGNED FORMAT
>
>   HBASE_OPTIONS
>
>   (
>
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
>
> COMPRESSION = 'SNAPPY',
>
> MEMSTORE_FLUSH_SIZE = '1073741824'
>
>   )
>
> ;
>
>
>
>
>
>
>
> Best regards,
>
> Yuan
>
> Email: yuan@esgyn.cn
>
> Cellphone: (+86) 13671935540 <+86%20136%207193%205540>
>
>
>

Re: installation prerequisites

[Carol Pearson]

Hi Sharu,

I think you can install CDH 5.3 on a supported Linux version (RHEL or
CentOS 6.x) directly, rather than a VM.  Trafodion doesn' run on Windows.
The VM and the asssocated helpers in the instructions are there to make it
easier.

Once you've got Trafodion installed, there are various things you can do
with it - see the quickstart page at
http://trafodion.apache.org/quickstart.html and feel free to make
suggestions or contributions as you discover things that could be done
differently to make it easier!

Again, welcome!
-Carol P

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Mon, Apr 4, 2016 at 12:41 PM, Sharu Gupta <gupta.sh...@gmail.com> wrote:

> Hello,
>
> I want to thank everybody for their responses and I am so sorry for such a
> delayed response.
>
> I will explain what I am trying to do. I am trying to install trafodion
> 1.3.0 binaries to experiment with trafodion as an end-user. I am referring
> to the steps in the provisioning guide for this purpose.
>
> Reading through the prerequisites and steps in the provisioning guide, I
> want to install the binaries on a virtual machine (single-node
> environment). I need CDH 5.3 hadoop distribution on the VM to get going.
> The problem I have is that when I go to
> http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see two
> options: download the VM installed with CDH 5.5 or CDH 5.4. (no option of
> getting VM with CDH 5.3 or under)
>
> Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I
> install CDH 5.3 hadoop distribution on my local machine and get started. I
> mean install hadoop CDH 5.3  and trafodion on my machine instead of VM.
>
> I am new to the hadoop world. Sorry if my questions are trivial. Thank you
> for your time.
>
> Sharu
>
>
>
>
>
>
>
>
> On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzo <c...@esgyn.com> wrote:
>
>> Hi Sharu,
>>
>>
>>
>> If you don’t want to wait for Trafodion 2.0 release (which will support
>> CDH 5.5), you can still find CDH 5.3 here:
>> http://www.cloudera.com/downloads/cdh/5-3-0.html
>>
>>
>>
>> Best,
>>
>> Christophe
>>
>>
>>
>>
>>
>> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com]
>> *Sent:* Friday, April 1, 2016 1:27 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: installation prerequisites
>>
>>
>>
>> Hi Sharu,
>>
>>
>>
>> First, welcome!  As Eric asks, are you trying out Trafodion as an
>> experiment, or do you have a particular use case in mind?
>>
>>
>>
>> The daily build that Amanda mentions is not necessarily ready for real
>> use - it's a snapshot build and so might contain incomplete fixes, partial
>> updates, limited documentation, etc.
>>
>>
>>
>> The developer daily build is not  recommended for general release usage
>> because it is a snapshot for testing purposes and so the quality
>> expectations are different.
>>
>>
>>
>> For more information on the daily build (especially if you're going to
>> try to install it), you can see the development list by subscribing to
>> dev-subscr...@apache.incubator.trafodion.org .  That list goes into deep
>> technical details, build mechanics and more - definitely not a
>> general-purpose user list, as the daily build is not a general-purpose
>> build!
>>
>>
>>
>> If you're interested in trying to build Trafodion or checking out a
>> developer build as part of becoming more deeply involved in Trafodion,
>> there are plenty of people on the dev list who can help you out!
>>
>>
>>
>> We're in the process of putting together Trafodion release 2.0 which is
>> the official path for supporting Trafodion on Cloudera 5.4.  I've been away
>> at a conference this week, so haven't seen the latest updates on release
>> 2.0, but it should be going to release candidate status very soon.
>>
>>
>>
>> Thanks and again, welcome!
>>
>>
>>
>> -Carol P.
>>
>>
>>
>>
>> ---
>>
>> Email:carol.pearson...@gmail.com
>>
>> Twitter:  @CarolP222
>>
>> ---
>>
>>
>>
>> On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta <gupta.sh...@gmail.com>
>> wrote:
>>
>> Hello,
>>
>>
>>
>> I am a new user on your mailing list. I was reading the instructions to
>> download and install Trafodion.
>>
>>
>>
>> The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are
>> required. However, I can only find CDH versions 5.4 or higher on
>>
>> http://www.cloudera.com/downloads/quickstart_vms/5-5.html
>>
>>
>>
>> Will it be OK to use hadoop distribution by CDH 5.4 or higher?
>>
>>
>>
>> Thank you,
>>
>> Sharu
>>
>>
>>
>
>

Re: installation prerequisites

[Carol Pearson]

Hi Sharu,

First, welcome!  As Eric asks, are you trying out Trafodion as an
experiment, or do you have a particular use case in mind?

The daily build that Amanda mentions is not necessarily ready for real use
- it's a snapshot build and so might contain incomplete fixes, partial
updates, limited documentation, etc.

The developer daily build is not  recommended for general release usage
because it is a snapshot for testing purposes and so the quality
expectations are different.

For more information on the daily build (especially if you're going to try
to install it), you can see the development list by subscribing to
dev-subscr...@apache.incubator.trafodion.org .  That list goes into deep
technical details, build mechanics and more - definitely not a
general-purpose user list, as the daily build is not a general-purpose
build!

If you're interested in trying to build Trafodion or checking out a
developer build as part of becoming more deeply involved in Trafodion,
there are plenty of people on the dev list who can help you out!

We're in the process of putting together Trafodion release 2.0 which is the
official path for supporting Trafodion on Cloudera 5.4.  I've been away at
a conference this week, so haven't seen the latest updates on release 2.0,
but it should be going to release candidate status very soon.

Thanks and again, welcome!

-Carol P.


---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta  wrote:

> Hello,
>
> I am a new user on your mailing list. I was reading the instructions to
> download and install Trafodion.
>
> The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are required.
> However, I can only find CDH versions 5.4 or higher on
> http://www.cloudera.com/downloads/quickstart_vms/5-5.html
>
> Will it be OK to use hadoop distribution by CDH 5.4 or higher?
>
> Thank you,
> Sharu
>

Re: HBase 0.98 vs HBase 1.1 in Trafodion Releases

[Carol Pearson]

Hi Stack,

Thanks for the reply!  I just want to clarify this:

API is a constant inside a major version, 1.x or 2.x, etc., but can change
across major versions.

In HBase, are Major versions things like 1.1 and 1.2?  I'm used to major
version being the number to the left of the decimal, so that 1.2 and 2.3
are different Major versions, while 1.2 and 1.3 are different minor
versions of the same major versions.

That is, build versions are of the form Major.Minor.buildversion

Am I misunderstanding?

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Wed, Mar 30, 2016 at 11:52 AM, Stack <st...@duboce.net> wrote:

> On Wed, Mar 30, 2016 at 9:25 AM, Gunnar Tapper <tapper.gun...@gmail.com>
> wrote:
>
>> 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.
>>
>
> No.
>
> API is a constant inside a major version, 1.x or 2.x, etc., but can change
> across major versions. HBase (almost) does http://semver.org/
>
> Having a wrapper for hbase 5.0 API so 1.0 clients don't have to change
> would be untenable or, if not that, a significant undertaking tough to
> resource in an open source project (who'd want to work on it?).
>
> St.Ack
>
>
>
>> On Mar 30, 2016 9:09 AM, "Stack" <st...@duboce.net> wrote:
>>
>>> On Wed, Mar 30, 2016 at 8:11 AM, Gunnar Tapper <tapper.gun...@gmail.com>
>>> 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 <st...@duboce.net> 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: Trafodion 1.3 Sandbox

[Carol Pearson]

Wow, this is great news!  I'm taking notes here and we need to put this on
the Getting Started page as a jumpstart for just playing with Trafodion.
Though perhaps initially it goes on the wiki until we are are settled on
the steps and troubleshooting/nuances.

But this is an easy way for people to experiment with the basics of
Trafodion.

Thanks Pierre!
-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Sun, Mar 27, 2016 at 10:29 AM, Pierre Smits 
wrote:

> Hi Amanda,
>
> Resolved that step too.
>
> This helped: http://trafodion.apache.org/port-assignment.html
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Sun, Mar 27, 2016 at 6:25 PM, Pierre Smits 
> wrote:
>
>> HI Amanda,
>>
>> Everything worked out fine. Now I am trying to connect from my mac where
>> the VirtualBox runs and into which I imported the download.
>>
>> For this I installed locally the t4driver and SQuirrel SQL client. But I
>> can't connect to the running VirtualBox instance. Where can I check the
>> port to connect to?
>>
>> Best regards,
>>
>>
>> Pierre Smits
>>
>> ORRTIZ.COM 
>> OFBiz based solutions & services
>>
>> OFBiz Extensions Marketplace
>> http://oem.ofbizci.net/oci-2/
>>
>> On Sun, Mar 27, 2016 at 4:27 PM, Amanda Moran 
>> wrote:
>>
>>> Sorry all! Forgot that in the steps!
>>>
>>> admin:admin
>>>
>>> This is the default for HDP.
>>>
>>> Thanks!
>>>
>>> Sent from my iPhone
>>>
>>> On Mar 27, 2016, at 7:21 AM, Pierre Smits 
>>> wrote:
>>>
>>> Hi Amanda,
>>>
>>> The steps up to #5 worked like a breeze. I used root/traf123 to login.
>>>
>>> #6: Open the browser and open Ambari to start all services didn't work.
>>> Starting this requires a userId and password too. So I couldn't continue.
>>>
>>> Best regards,
>>>
>>> Pierre Smits
>>>
>>> ORRTIZ.COM 
>>> OFBiz based solutions & services
>>>
>>> OFBiz Extensions Marketplace
>>> http://oem.ofbizci.net/oci-2/
>>>
>>> On Fri, Mar 25, 2016 at 9:48 PM, Amanda Moran 
>>> wrote:
>>>
 Hi there All-

 I have created a Trafodion 1.3 VirtualBox VM with HDP 2.2.

 https://www.dropbox.com/s/5i2fk4nbpltw11m/trafodion_1.3.ova?dl=0

 *Instructions *


1. Download sandbox (this will take a bit of time :))
2. Import Sandbox into VirtualBox
3. Under "Settings-> Network" you will need to toggle these
settings to match your set up, so that you have an internet connect on 
 the
VM and a way to access the VM via putty/winscp etc. This will take some
experimenting on your part. HDP has issues starting up if this isn't set
correcting.
4. Start VM
5. Select "other" at log in: root/traf123 or log in as
trafodion/traf123
6. Open Firefox -> Open Ambari (localhost:8080) -> Start All
services
7. Once everything is started open a terminal -> hbase shell ->
status (If no errors come up then everything started correctly... do not
try to start Trafodion if HDFS/HBase has not come up).
8. sudo su trafodion
9. sqstart
10. sqlci -> create table -> get table


 Thanks! Let me know if you have any issues or feedback :)

 --
 Thanks,

 Amanda Moran

>>>
>>>
>>
>

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

[Carol Pearson]

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

Re: perl-DBD-SQLite*

[Carol Pearson]

Hi Amanda,

At one point, I know we used SQLite for some internal configuration
information, but I've lost track of whether or not we still do.  Otherwise,
SQLite would be needed for a dependency, and at that point and we'd have to
track that one down to see what's really needed.

If we don't install the full set, does the install complete and does
Trafodion start? No guarantees that we don't have a problem if it installs
and starts because the dependency could be later in the execution path.
But if install/start fails, at least that tells us that the dependency
matters and points us to at least one place *where* something cares.

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Tue, Mar 8, 2016 at 2:55 PM, Amanda Moran  wrote:

> Hi there All-
>
> In the current installer we try to install this package: perl-DBD-SQLite*
> (note the *), on RHEL 6 and Centos 6 this has worked fine.
>
> I am testing the installer on RHEL 7.1 and it is not able to install 
> perl-DBD-SQLite*
> only perl-DBD-SQLite.
>
> Is just installing perl-DBD-SQLite going to be an issue?
>
> Thanks!
>
> --
> Thanks,
>
> Amanda Moran
>

Apache Trafodion At San Jose Strata + Hadoop World Developer Showcase!

[Carol Pearson]

Hi Trafodion Fans,

Great news if you're going to Strata + Hadoop World in San Jose at the end
of March.  Apache Trafodion was selected to be part of the Developer
Showcase on Wednesday, 30March!  Stop by to see Apache Trafodion in action
and to talk to some of the people in the Trafodion community in person.

This is also a great opportunity to get some ideas on how you could join in
on the Trafodion fun!

-Carol P.
---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

Re: 答复: 答复: RMS questions

[Carol Pearson]

ODB does taxes?  Are you sure you're not talking about emacs? I think it
has a file-taxes-mode (maybe one per US state?), all written in e-lisp and
with embedded tax tables  (*ducks*)

But seriously, Gunnar's right.  The documentation that we have in the
various guides for Trafodion is very detailed.  And if something is
missing, we should go add it so people have decent references for what
Trafodion can do.  If someone out there wants to take on helping to
organize/extend our documentation, that would be a great place to
contribute.

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Wed, Mar 2, 2016 at 3:05 PM, Gunnar Tapper 
wrote:

> 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 

Re: 答复: 答复: Logo Proposal

[Carol Pearson]

Nope, not yet on the official vote - still making sure everyone who wants
to offer an opinion from China (or anywhere else, but Chinese New Year was
last week so they were not thinking about Trafodion Logos, I'm betting...)
has a chance.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Tue, Feb 16, 2016 at 1:24 PM, D. Markt <dmarkt7...@gmail.com> wrote:

> I didn’t vote because I was waiting for the run-off/official vote.  If
> we’re in it, then we should tell all that’s the case and I’ll vote on the
> current options.
>
>
>
> Thanks,
>
> Dennis
>
>
>
> *From:* Dave Birdsall [mailto:dave.birds...@esgyn.com]
> *Sent:* Tuesday, February 16, 2016 12:31 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* RE: 答复: 答复: Logo Proposal
>
>
>
> Hi,
>
>
>
> Looks like consensus is crystallizing around options 13 and 4G. There were
> a couple of comments on 4G regarding font color. I don’t know if Ken wants
> to put up a revised 4G with a different color scheme.
>
>
>
> I’m wondering if we should do an informal run-off between 13 and 4G (or a
> revised 4G if Ken so desires) and decide on that basis?
>
>
>
> Dave
>
>
>
> *From:* Kevin DeYager [mailto:kevin.deya...@gmail.com]
> *Sent:* Tuesday, February 16, 2016 10:26 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: 答复: Logo Proposal
>
>
>
> +1 to 13
>
>
>
>
>
> Here's what the current vote tally looks like.
>
> Option
>
> 13
>
> 4G
>
> 8
>
> 12
>
> Ken Holt
>
> Tina Krug
>
> 1
>
> 1
>
> Sean Broeder
>
> 1
>
> 1
>
> Sandya Sundaresan
>
> 1
>
> 1
>
> Hans Zeller
>
> 1
>
> 1
>
> Rohit Jain
>
> 1
>
> Wei-Shun Tsai
>
> 1
>
> 1
>
> Hai Lin (Henry)
>
> 1
>
> Qifan Chen
>
> 1
>
> Ming Liu
>
> 1
>
> Narendra Goyal
>
> 1
>
> 1
>
> Atanu Mishra
>
> 1
>
> Carol Pearson
>
> 1
>
> 1
>
> Venkat Muthuswamy
>
> Amanda Moran
>
> 1
>
> 1
>
> Jian Jin (Seth)
>
> 1
>
> Christophe LeRouzo
>
> 1
>
> 1
>
> Prashanth Vasudev
>
> 1
>
> 1
>
>
>
> Dave Birdsall
>
> 1
>
> Kevin DeYager
>
> 1
>
> 14
>
> 10
>
> 3
>
> 1
>
>
>
>
>
> On Tue, Feb 16, 2016 at 9:52 AM, Gunnar Tapper <tapper.gun...@gmail.com>
> wrote:
>
> +1
>
>
>
> On Tue, Feb 16, 2016 at 10:38 AM, Steve Varnau <steve.var...@esgyn.com>
> 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) <ming@esgyn.cn>
> 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

[Carol Pearson]

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 <tapper.gun...@gmail.com>
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, 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 <knhknhknh...@gmail.com> 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 

Re: Basic Is-it-working? Test

[Carol Pearson]

Shoot, now I'm gonna have to go check whether I cut and pasted the right
one... The one I used most recently didn't have any syntax errors in it

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Tue, Feb 2, 2016 at 10:13 AM, Anoop Sharma <anoop.sha...@esgyn.com>
wrote:

> hey
>
> did you run this script? Coz there is a syntax error in it.
>
> Now run it and find out which stmt has  syntax error J
>
> anoop
>
>
>
> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com]
> *Sent:* Tuesday, February 2, 2016 10:12 AM
> *To:* u...@trafodion.apache.org
> *Subject:* Basic Is-it-working? Test
>
>
>
> Hi Trafodion Fans,
>
>
>
> I wrote a little one-minute acid test script to make sure that my
> Trafodion basic piece-parts are in working order before doing more complex
> testing.  Whenever I do an installation or an sqstart after changing
> configuration, I run this script just to make sure that nothing is horribly
> broken.  If I get errors, I know there's no point in going further because
> something basic went wrong.
>
>
>
> ---
>
> --
>
> --  Acid test script to make sure SQL has installed
>
> --
>
> --
>
>
>
> create schema test_sandbox_schema;
>
>
>
> set schema test_sandbox_schema;
>
>
>
> create table t (c1 int not null, c2 int not null, primary key (c1));
>
>
>
> insert into t values (1,1);
>
> insert into t values (2,3);
>
> insert into t values (3,2);
>
> begin work;
>
> insert into t values (4,5);
>
> insert into t values (5,2);
>
> commit work;
>
>
>
> insert into t values (7,3);
>
>
>
> select * from t order by c2;
>
>
>
> create index tix on t (c2);
>
>
>
> create view tview as select c1, c2 from t where c2 > 3;
>
>
>
> select * from tview where c2 < 3;
>
> select * from tview where c2 > 2;
>
>
>
> update statistics on t;
>
>
>
> explain select * from t order by c2;
>
> select * from t order by c2;
>
>
>
> drop view tview;
>
> drop table t;
>
> drop schema test_sandbox_schema;
>
>
>
>
>
>
>
> I put emphasis on sorting and indexes because of my long history with
> those (old habits die hard). And my goal is only basic success (no errors)
> and I don't mind repeating the same query multiple times and I do expect
> the same results I don't want a huge complex script and automated
> validation (those come next, depending on what I'm trying to do).  Really,
> my goal is to get a fast warm fuzzy feeling that it's worth it for me to
> actually do real work.
>
>
>
> Anyone have suggestions on other things I might  check as part of a
> simple, less than one-minute test?  Is this (incredibly basic) script worth
> contributing to Trafodion?
>
>
>
> Thanks!
>
> -Carol P.
>
>
> ---
>
> Email:carol.pearson...@gmail.com
>
> Twitter:  @CarolP222
>
> ---
>

Basic Is-it-working? Test

[Carol Pearson]

Hi Trafodion Fans,

I wrote a little one-minute acid test script to make sure that my Trafodion
basic piece-parts are in working order before doing more complex testing.
Whenever I do an installation or an sqstart after changing configuration, I
run this script just to make sure that nothing is horribly broken.  If I
get errors, I know there's no point in going further because something
basic went wrong.

---
--
--  Acid test script to make sure SQL has installed
--
--

create schema test_sandbox_schema;

set schema test_sandbox_schema;

create table t (c1 int not null, c2 int not null, primary key (c1));

insert into t values (1,1);
insert into t values (2,3);
insert into t values (3,2);
begin work;
insert into t values (4,5);
insert into t values (5,2);
commit work;

insert into t values (7,3);

select * from t order by c2;

create index tix on t (c2);

create view tview as select c1, c2 from t where c2 > 3;

select * from tview where c2 < 3;
select * from tview where c2 > 2;

update statistics on t;

explain select * from t order by c2;
select * from t order by c2;

drop view tview;
drop table t;
drop schema test_sandbox_schema;




I put emphasis on sorting and indexes because of my long history with those
(old habits die hard). And my goal is only basic success (no errors) and I
don't mind repeating the same query multiple times and I do expect the same
results I don't want a huge complex script and automated validation
(those come next, depending on what I'm trying to do).  Really, my goal is
to get a fast warm fuzzy feeling that it's worth it for me to actually do
real work.

Anyone have suggestions on other things I might  check as part of a simple,
less than one-minute test?  Is this (incredibly basic) script worth
contributing to Trafodion?

Thanks!
-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

Re: Basic Is-it-working? Test

[Carol Pearson]

Yep, issue was the update stats command - needs to be "for" not "on".  I
thought I copied the right version, but apparently not. That's why source
control is a handy thing

Thanks Anoop!

-Carol P.

---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---

On Tue, Feb 2, 2016 at 10:59 AM, Carol Pearson <carol.pearson...@gmail.com>
wrote:

> Shoot, now I'm gonna have to go check whether I cut and pasted the right
> one... The one I used most recently didn't have any syntax errors in it
>
> -Carol P.
>
> ---
> Email:carol.pearson...@gmail.com
> Twitter:  @CarolP222
> ---
>
> On Tue, Feb 2, 2016 at 10:13 AM, Anoop Sharma <anoop.sha...@esgyn.com>
> wrote:
>
>> hey
>>
>> did you run this script? Coz there is a syntax error in it.
>>
>> Now run it and find out which stmt has  syntax error J
>>
>> anoop
>>
>>
>>
>> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com]
>> *Sent:* Tuesday, February 2, 2016 10:12 AM
>> *To:* u...@trafodion.apache.org
>> *Subject:* Basic Is-it-working? Test
>>
>>
>>
>> Hi Trafodion Fans,
>>
>>
>>
>> I wrote a little one-minute acid test script to make sure that my
>> Trafodion basic piece-parts are in working order before doing more complex
>> testing.  Whenever I do an installation or an sqstart after changing
>> configuration, I run this script just to make sure that nothing is horribly
>> broken.  If I get errors, I know there's no point in going further because
>> something basic went wrong.
>>
>>
>>
>> ---
>>
>> --
>>
>> --  Acid test script to make sure SQL has installed
>>
>> --
>>
>> --
>>
>>
>>
>> create schema test_sandbox_schema;
>>
>>
>>
>> set schema test_sandbox_schema;
>>
>>
>>
>> create table t (c1 int not null, c2 int not null, primary key (c1));
>>
>>
>>
>> insert into t values (1,1);
>>
>> insert into t values (2,3);
>>
>> insert into t values (3,2);
>>
>> begin work;
>>
>> insert into t values (4,5);
>>
>> insert into t values (5,2);
>>
>> commit work;
>>
>>
>>
>> insert into t values (7,3);
>>
>>
>>
>> select * from t order by c2;
>>
>>
>>
>> create index tix on t (c2);
>>
>>
>>
>> create view tview as select c1, c2 from t where c2 > 3;
>>
>>
>>
>> select * from tview where c2 < 3;
>>
>> select * from tview where c2 > 2;
>>
>>
>>
>> update statistics on t;
>>
>>
>>
>> explain select * from t order by c2;
>>
>> select * from t order by c2;
>>
>>
>>
>> drop view tview;
>>
>> drop table t;
>>
>> drop schema test_sandbox_schema;
>>
>>
>>
>>
>>
>>
>>
>> I put emphasis on sorting and indexes because of my long history with
>> those (old habits die hard). And my goal is only basic success (no errors)
>> and I don't mind repeating the same query multiple times and I do expect
>> the same results I don't want a huge complex script and automated
>> validation (those come next, depending on what I'm trying to do).  Really,
>> my goal is to get a fast warm fuzzy feeling that it's worth it for me to
>> actually do real work.
>>
>>
>>
>> Anyone have suggestions on other things I might  check as part of a
>> simple, less than one-minute test?  Is this (incredibly basic) script worth
>> contributing to Trafodion?
>>
>>
>>
>> Thanks!
>>
>> -Carol P.
>>
>>
>> ---
>>
>> Email:carol.pearson...@gmail.com
>>
>> Twitter:  @CarolP222
>>
>> ---
>>
>
>

Dropping Schema blocked if histograms exist?

[Carol Pearson]

I was trying to drop a schema after I updated statistics on the table.  I'd
dropped all of the objects that I created in the schema (one table,
cjpjunk, because that's all I was testing...) but my drop schema failed:

>>drop schema test_sandbox_schema;

*** ERROR[1028] The schema must be empty.  It contains at least one object
SB_HISTOGRAMS.

--- SQL operation failed with errors.



So I selected from the OBJECTS metadata table to see what's in the
test_sandbox_schema, and all I see are histograms tables, created when I
updated stats on good ol' cjpjunk:

>>select distinct object_name from "_MD_".objects where schema_name like
'TEST_SANDBOX_SCHEMA%';

OBJECT_NAME
---

SB_HISTOGRAMS
SB_HISTOGRAMS_PK
SB_HISTOGRAM_INTERVALS
SB_HISTOGRAM_INTERVALS_PK
__SCHEMA__
--- 5 row(s) selected.


Nothing but system-created tables, and the SB_HISTOGRAMS tables exist only
because I did an UPDATE STATISTICS command.

Now, I'm able to drop the schema with a drop schema cascade command:

>>drop schema test_sandbox_schema cascade;

--- SQL operation complete.



but why was cascade required?  Shouldn't I be able to drop the schema
without cascade since I didn't physically create any of these objects, and
wouldn't generally need to be aware of them from a user perspective?

Thanks!
-Carol P.
---
Email:carol.pearson...@gmail.com
Twitter:  @CarolP222
---