Hi, +1 on Dave's CQD solution. Also, it might be good if we just install snappy on our workstations to avoid issues.
We already have other CQDs that follow this approach, for the default character sets, default byte semantics, allowing nullable keys, Hive string length, etc.. I think that KISS could mean different things to different people. The CQDs are purely optional, and for some people they make life simpler. If not, it's very simple - just don't use them. SHOWDDL spells out all the options, if people want to see what's actually applied. Thanks, Hans From: Dave Birdsall [mailto:dave.birds...@esgyn.com] Sent: Wednesday, June 7, 2017 9: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<mailto: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 sooooo 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<mailto: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<mailto: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<mailto: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)" <yuan....@esgyn.cn<mailto:yuan....@esgyn.cn>> Date: 6/6/17 10:29 PM (GMT-06:00) To: user@trafodion.incubator.apache.org<mailto: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<mailto:yuan....@esgyn.cn> Cellphone: (+86) 13671935540
