date:20180524

[jira] [Commented] (TRAFODION-3084) Cannot create comment on HBASE table

2018-05-24 Thread zhang.lei (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16490183#comment-16490183
 ] 

zhang.lei commented on TRAFODION-3084:
--

Hi, [~anoopsharma] , I'm so happy that you told us the real reason for this 
problem. as you said, I succeeded after registered it.  then i do 'SHOWDDL' ,  
but comments is not displayed,  is this normal?


 

>>comment on table test03 is 'test03';

--- SQL operation complete.
>>showddl test03;

/* Hive DDL */
CREATE TABLE DEFAULT.TEST03
 (
 A bigint
 , B char(4)
 , C char(4)
 )
 stored as textfile
;

/* Trafodion DDL */

REGISTER HIVE TABLE HIVE.HIVE.TEST03;
/* ObjectUID = 8608229581284533233 */

-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HIVE.HIVE.TEST03 TO 
DB__HIVEROLE WITH GRANT OPTION;

--- SQL operation complete.
>>

 

And i have anther small question:  After a HIVE/HBase table is deleted from 
hbase shell, we also unregister it? 

 

> Cannot create comment on HBASE table
> 
>
> Key: TRAFODION-3084
> URL: https://issues.apache.org/jira/browse/TRAFODION-3084
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: shaoyong.li
>Assignee: shaoyong.li
>Priority: Major
>
> I found I cannot direct create comment on hbase table. 
>  SQL>comment on table hbase."_CELL_"."cdr" is 'test'
> ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
> [2018-05-14 15:55:40]
> But, after doing update statistics on hbase table successfully, comment 
> statement runs successfully on hbase table.
> SQL>update statistics for table hbase."_CELL_"."cdr" on every column;
> — SQL operation complete.
> SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';
> — SQL operation complete.
> SQL>showddl hbase."_CELL_"."cdr";
> /*
>  CREATE TABLE HBASE."_CELL_"."cdr"
>    (
>      ROW_ID VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
>    NOT SERIALIZED
>    , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , PRIMARY KEY (ROW_ID ASC)
>    )
>  ;
>  */
> /* HBase DDL */
>  CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')
> REGISTER /*INTERNAL*/ HBASE TABLE cdr;
>  /* ObjectUID = 6735857105763057363 */
> COMMENT ON TABLE HBASE."_CELL_"."cdr" IS 'test cdr' ;
> – GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."_CELL_"."cdr" TO 
> DB__HBASEROLE WITH GRANT OPTION;
> — SQL operation complete.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16490154#comment-16490154
 ] 

ASF GitHub Bot commented on TRAFODION-3085:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1580#discussion_r190780316
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -1484,16 +1484,21 @@ EXECUTE y;  -- uses 
MYSCHEMA;
 [[control_query_default_examples]]
 === Examples of CONTROL QUERY DEFAULT
 
-* Increase the cache refresh time for the histogram cache to two hours 
(7,200 minutes).
+* This example changes the maximum degree of parallelism to 2 for a query. 
The value must be less than the number of CPUs in the cluster.
 +
 ```
-CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL '7200';
+SQL>CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS '2';
+
+--- SQL operation complete.
 ```
 
-* Reset the CACHE_HISTOGRAMS_REFRESH_INTERVAL attribute to its initial 
value in the current process:
+* This example resets the `PARALLEL_NUM_ESPS` attribute to its system 
value in the current process, 
+in this case, the compiler calculates the number of ESPs to be used.
--- End diff --

Thanks Dave, I've changed :v: :octocat:


> Add Examples for *CONTROL QUERY DEFAULT Statement* in *Trafodion SQL 
> Reference Manual*
> --
>
> Key: TRAFODION-3085
> URL: https://issues.apache.org/jira/browse/TRAFODION-3085
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16490116#comment-16490116
 ] 

ASF GitHub Bot commented on TRAFODION-3070:
---

Github user zlei929 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1578#discussion_r190774048
  
--- Diff: core/sql/sqlcomp/CmpSeabaseDDLcommentOn.cpp ---
@@ -229,6 +229,16 @@ void  
CmpSeabaseDDL::doSeabaseCommentOn(StmtDDLCommentOn   *commentOnNode,
   enum ComObjectType enMDObjType = COM_UNKNOWN_OBJECT;
 
   ComObjectName objectName(commentOnNode->getObjectName());
+  //we can not comment on native hive table.
+  if (str_cmp(toUpper(currCatName.data()), "HIVE", 4) == 0)
--- End diff --

Thank you for your reminding~!   i will create a new pull request after 
changed this.


> Cannot create comment on HIVE table
> ---
>
> Key: TRAFODION-3070
> URL: https://issues.apache.org/jira/browse/TRAFODION-3070
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: any
>Reporter: zhang.lei
>Assignee: zhang.lei
>Priority: Major
> Fix For: any
>
>
> I cannot create comment on HIVE table.
> SQL>comment on table hive.hive.test01 is 'test';
>   ---ERROR[1389] Object HIVE.HIVE.TEST01 does not exist in Trafodion. 
> [2018-05-14 15:51:31]
> Then I create an external table in trafci for the hive table.
> SQL>create external table test01(a largeint,b varchar(4), c varchar(4)) for 
> hive.hive.test01;
> — SQL operation complete.
> And I found I can create comment on the external table.
> SQL>comment on table "__HV_HIVE__".test01 is 'test';
> — SQL operation complete.
> SQL>showddl "__HV_HIVE__".test01;
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
>  ;
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> After that, I try to create comment on the HIVE table.
>  The comment statement completes and I check ddls of the HIVE table.
>  But the comment 'test0102' doesn't appear in the ddl.
>  And comment statement are in front of the semicolon that is the end sign for 
> external table ddl.
> SQL>comment on table hive.hive.test01 is 'test0102';
> — SQL operation complete.
> SQL>showddl hive.hive.test01;
> /* Hive DDL */
>  CREATE TABLE DEFAULT.TEST01
>    (
>  A bigint
>    , B char(4)
>    , C char(4)
>    )
>    stored as textfile
>  ;
> /* Trafodion DDL */
> REGISTER /*INTERNAL*/ HIVE TABLE HIVE.HIVE.TEST01;
>  /* ObjectUID = 1137319817757950657 */
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> ;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (TRAFODION-3086) Traf support for DDL operations directly on Hive objects

2018-05-24 Thread Anoop Sharma (JIRA)

Anoop Sharma created TRAFODION-3086:
---

 Summary: Traf support for DDL operations directly on Hive objects  
 Key: TRAFODION-3086
 URL: https://issues.apache.org/jira/browse/TRAFODION-3086
 Project: Apache Trafodion
  Issue Type: New Feature
Reporter: Anoop Sharma
Assignee: Anoop Sharma


A previous Jira, TRAFODION-2498, added support to pass through some DDL 
commands to hive API. It was done via:  process hive statement 
'hive-ddl-command' syntax. The supplied command was passed in as-is to the 
underlying interface.

This current Jira is to add support to directly perform DDL operations on Hive 
objects without having to use 'process hive statement'. 

  Example:  create table hive.hive.t (...)  ...

  or:     alter table hive.hivesch.t 

With this enhancement, Hive objects will be treated similar to traf objects 
while performing DDL operations. Things like registration/unregistration in 
traf MD, query invalidation, cleanup, etc will be done automatically.

A detailed spec/note will be added later.

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

2018-05-24 Thread Anoop Sharma (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489433#comment-16489433
 ] 

Anoop Sharma commented on TRAFODION-3070:
-

See  comments in trafodion-3084 regarding registration of tables before issuing 
comment command.

> Cannot create comment on HIVE table
> ---
>
> Key: TRAFODION-3070
> URL: https://issues.apache.org/jira/browse/TRAFODION-3070
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: any
>Reporter: zhang.lei
>Assignee: zhang.lei
>Priority: Major
> Fix For: any
>
>
> I cannot create comment on HIVE table.
> SQL>comment on table hive.hive.test01 is 'test';
>   ---ERROR[1389] Object HIVE.HIVE.TEST01 does not exist in Trafodion. 
> [2018-05-14 15:51:31]
> Then I create an external table in trafci for the hive table.
> SQL>create external table test01(a largeint,b varchar(4), c varchar(4)) for 
> hive.hive.test01;
> — SQL operation complete.
> And I found I can create comment on the external table.
> SQL>comment on table "__HV_HIVE__".test01 is 'test';
> — SQL operation complete.
> SQL>showddl "__HV_HIVE__".test01;
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
>  ;
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> After that, I try to create comment on the HIVE table.
>  The comment statement completes and I check ddls of the HIVE table.
>  But the comment 'test0102' doesn't appear in the ddl.
>  And comment statement are in front of the semicolon that is the end sign for 
> external table ddl.
> SQL>comment on table hive.hive.test01 is 'test0102';
> — SQL operation complete.
> SQL>showddl hive.hive.test01;
> /* Hive DDL */
>  CREATE TABLE DEFAULT.TEST01
>    (
>  A bigint
>    , B char(4)
>    , C char(4)
>    )
>    stored as textfile
>  ;
> /* Trafodion DDL */
> REGISTER /*INTERNAL*/ HIVE TABLE HIVE.HIVE.TEST01;
>  /* ObjectUID = 1137319817757950657 */
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> ;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3084) Cannot create comment on HBASE table

2018-05-24 Thread Anoop Sharma (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489429#comment-16489429
 ] 

Anoop Sharma commented on TRAFODION-3084:
-

comment can be added on an object which has an object uid in traf metadata 
OBJECTS table.

If an hbase table is created from hbase shell, then it needs to be registered 
in traf metadata first.

upd stats internally registers it which is why comment could be added after 
that.

To explicitly register it, do:

  register hbase table 

 

Example:

>>comment on table hbase."_CELL_".myhbt is 'test';

*** ERROR[1389] Object HBASE."_CELL_".MYHBT does not exist in Trafodion.

--- SQL operation failed with errors.
>>register hbase table hbase."_CELL_".myhbt;

--- SQL operation complete.
>>
>>comment on table hbase."_CELL_".myhbt is 'test';

--- SQL operation complete.
>>

 

Same issue will show up with native hive tables. They need to be registered in 
traf metadata before doing any traf related operation. 

>>comment on table hive.hive.myht is 'test';

*** ERROR[1389] Object HIVE.HIVE.MYHT does not exist in Trafodion.

--- SQL operation failed with errors.
>>register hive table hive.hive.myht;

--- SQL operation complete.
>>
>>comment on table hive.hive.myht is 'test';

--- SQL operation complete.
>>

 

We should also fix code to automatically register HBase/Hive tables if 
'comment' operations is done on them. That way users will not have to 
explicitly register them. This will be similar to how they are automatically 
registered on some traf operations, like upd stats, or creating an external 
table, or views, etc.

 

> Cannot create comment on HBASE table
> 
>
> Key: TRAFODION-3084
> URL: https://issues.apache.org/jira/browse/TRAFODION-3084
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: shaoyong.li
>Assignee: shaoyong.li
>Priority: Major
>
> I found I cannot direct create comment on hbase table. 
>  SQL>comment on table hbase."_CELL_"."cdr" is 'test'
> ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
> [2018-05-14 15:55:40]
> But, after doing update statistics on hbase table successfully, comment 
> statement runs successfully on hbase table.
> SQL>update statistics for table hbase."_CELL_"."cdr" on every column;
> — SQL operation complete.
> SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';
> — SQL operation complete.
> SQL>showddl hbase."_CELL_"."cdr";
> /*
>  CREATE TABLE HBASE."_CELL_"."cdr"
>    (
>      ROW_ID VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
>    NOT SERIALIZED
>    , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , PRIMARY KEY (ROW_ID ASC)
>    )
>  ;
>  */
> /* HBase DDL */
>  CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')
> REGISTER /*INTERNAL*/ HBASE TABLE cdr;
>  /* ObjectUID = 6735857105763057363 */
> COMMENT ON TABLE HBASE."_CELL_"."cdr" IS 'test cdr' ;
> – GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."_CELL_"."cdr" TO 
> DB__HBASEROLE WITH GRANT OPTION;
> — SQL operation complete.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489296#comment-16489296
 ] 

ASF GitHub Bot commented on TRAFODION-3070:
---

Github user DaveBirdsall commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1578#discussion_r190645661
  
--- Diff: core/sql/sqlcomp/CmpSeabaseDDLcommentOn.cpp ---
@@ -229,6 +229,16 @@ void  
CmpSeabaseDDL::doSeabaseCommentOn(StmtDDLCommentOn   *commentOnNode,
   enum ComObjectType enMDObjType = COM_UNKNOWN_OBJECT;
 
   ComObjectName objectName(commentOnNode->getObjectName());
+  //we can not comment on native hive table.
+  if (str_cmp(toUpper(currCatName.data()), "HIVE", 4) == 0)
--- End diff --

Please use the literal HIVE_SYSTEM_CATALOG (see common/ComSmallDefs.h) 
instead of hard-coding "HIVE".


> Cannot create comment on HIVE table
> ---
>
> Key: TRAFODION-3070
> URL: https://issues.apache.org/jira/browse/TRAFODION-3070
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: any
>Reporter: zhang.lei
>Assignee: zhang.lei
>Priority: Major
> Fix For: any
>
>
> I cannot create comment on HIVE table.
> SQL>comment on table hive.hive.test01 is 'test';
>   ---ERROR[1389] Object HIVE.HIVE.TEST01 does not exist in Trafodion. 
> [2018-05-14 15:51:31]
> Then I create an external table in trafci for the hive table.
> SQL>create external table test01(a largeint,b varchar(4), c varchar(4)) for 
> hive.hive.test01;
> — SQL operation complete.
> And I found I can create comment on the external table.
> SQL>comment on table "__HV_HIVE__".test01 is 'test';
> — SQL operation complete.
> SQL>showddl "__HV_HIVE__".test01;
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
>  ;
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> After that, I try to create comment on the HIVE table.
>  The comment statement completes and I check ddls of the HIVE table.
>  But the comment 'test0102' doesn't appear in the ddl.
>  And comment statement are in front of the semicolon that is the end sign for 
> external table ddl.
> SQL>comment on table hive.hive.test01 is 'test0102';
> — SQL operation complete.
> SQL>showddl hive.hive.test01;
> /* Hive DDL */
>  CREATE TABLE DEFAULT.TEST01
>    (
>  A bigint
>    , B char(4)
>    , C char(4)
>    )
>    stored as textfile
>  ;
> /* Trafodion DDL */
> REGISTER /*INTERNAL*/ HIVE TABLE HIVE.HIVE.TEST01;
>  /* ObjectUID = 1137319817757950657 */
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> ;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3082) Add populate-option for CREATE INDEX Statement and fix typos in Trafodion SQL Reference Manual

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489215#comment-16489215
 ] 

ASF GitHub Bot commented on TRAFODION-3082:
---

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1575


> Add *populate-option* for *CREATE INDEX Statement* and fix typos in 
> *Trafodion SQL Reference Manual*
> 
>
> Key: TRAFODION-3082
> URL: https://issues.apache.org/jira/browse/TRAFODION-3082
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Resolved] (TRAFODION-3083) Trafodion compiles fail on CentOS7

2018-05-24 Thread David Wayne Birdsall (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Wayne Birdsall resolved TRAFODION-3083.
-
   Resolution: Fixed
Fix Version/s: 2.3

> Trafodion compiles fail on CentOS7
> --
>
> Key: TRAFODION-3083
> URL: https://issues.apache.org/jira/browse/TRAFODION-3083
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dev-environment
>Affects Versions: 2.3
>Reporter: David Wayne Birdsall
>Assignee: David Wayne Birdsall
>Priority: Major
> Fix For: 2.3
>
>
> The "make all" step when building Trafodion on a CentOS7 instance fails with 
> the following errors:
> {quote}/lib64/libpthread.so.0: error adding symbols: DSO missing from command 
> line ##(SQF)
> collect2: error: ld returned 1 exit status ##(SQF)
> {quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3083) Trafodion compiles fail on CentOS7

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16489202#comment-16489202
 ] 

ASF GitHub Bot commented on TRAFODION-3083:
---

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1576


> Trafodion compiles fail on CentOS7
> --
>
> Key: TRAFODION-3083
> URL: https://issues.apache.org/jira/browse/TRAFODION-3083
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dev-environment
>Affects Versions: 2.3
>Reporter: David Wayne Birdsall
>Assignee: David Wayne Birdsall
>Priority: Major
>
> The "make all" step when building Trafodion on a CentOS7 instance fails with 
> the following errors:
> {quote}/lib64/libpthread.so.0: error adding symbols: DSO missing from command 
> line ##(SQF)
> collect2: error: ld returned 1 exit status ##(SQF)
> {quote}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16488677#comment-16488677
 ] 

ASF GitHub Bot commented on TRAFODION-3085:
---

GitHub user liuyu000 opened a pull request:

https://github.com/apache/trafodion/pull/1580

[TRAFODION-3085] Add Examples for *CONTROL QUERY DEFAULT Statement* in 
*Trafodion SQL Reference Manual*

The CQD `CACHE_HISTOGRAMS_REFRESH_INTERVAL` has been removed.

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/liuyu000/trafodion CQD_Example

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1580.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1580


commit f5c28e9656b56c58f1009080448169f0be1503c3
Author: liu.yu 
Date:   2018-05-24T08:54:17Z

Add Examples for *CONTROL QUERY DEFAULT Statement* in *Trafodion SQL 
Reference Manual*




> Add Examples for *CONTROL QUERY DEFAULT Statement* in *Trafodion SQL 
> Reference Manual*
> --
>
> Key: TRAFODION-3085
> URL: https://issues.apache.org/jira/browse/TRAFODION-3085
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

2018-05-24 Thread Liu Yu (JIRA)

Liu Yu created TRAFODION-3085:
-

 Summary: Add Examples for *CONTROL QUERY DEFAULT Statement* in 
*Trafodion SQL Reference Manual*
 Key: TRAFODION-3085
 URL: https://issues.apache.org/jira/browse/TRAFODION-3085
 Project: Apache Trafodion
  Issue Type: Documentation
Reporter: Liu Yu
Assignee: Liu Yu






--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (TRAFODION-3084) Cannot create comment on HBASE table

2018-05-24 Thread shaoyong.li (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

shaoyong.li updated TRAFODION-3084:
---
Description: 
I found I cannot direct create comment on hbase table. 
 SQL>comment on table hbase."_CELL_"."cdr" is 'test'

ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
[2018-05-14 15:55:40]

But, after doing update statistics on hbase table successfully, comment 
statement runs successfully on hbase table.

SQL>update statistics for table hbase."_CELL_"."cdr" on every column;

— SQL operation complete.

SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';

— SQL operation complete.

SQL>showddl hbase."_CELL_"."cdr";

/*
 CREATE TABLE HBASE."_CELL_"."cdr"
   (
     ROW_ID VARCHAR(100) CHARACTER SET ISO88591
   COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
   COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
   COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
   NOT SERIALIZED
   , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
   COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
   , PRIMARY KEY (ROW_ID ASC)
   )
 ;
 */

/* HBase DDL */
 CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')

REGISTER /*INTERNAL*/ HBASE TABLE cdr;
 /* ObjectUID = 6735857105763057363 */

COMMENT ON TABLE HBASE."_CELL_"."cdr" IS 'test cdr' ;

– GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."_CELL_"."cdr" TO 
DB__HBASEROLE WITH GRANT OPTION;

— SQL operation complete.

  was:
I found I cannot direct create comment on hbase table. 
SQL>comment on table hbase."_CELL_"."cdr" is 'test';

*** ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
[2018-05-14 15:55:40]


But, after doing update statistics on hbase table successfully, comment 
statement runs successfully on hbase table.

SQL>update statistics for table hbase."_CELL_"."cdr" on every column;

--- SQL operation complete.

SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';

--- SQL operation complete.

SQL>showddl hbase."_CELL_"."cdr";


/*
CREATE TABLE HBASE."_CELL_"."cdr"
  (
    ROW_ID VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  NOT SERIALIZED
  , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , PRIMARY KEY (ROW_ID ASC)
  )
;
*/

/* HBase DDL */
CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')

REGISTER /*INTERNAL*/ HBASE TABLE cdr;
/* ObjectUID = 6735857105763057363 */

COMMENT ON TABLE HBASE."_CELL_"."cdr" IS 'test cdr' ;

-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."_CELL_"."cdr" TO 
DB__HBASEROLE WITH GRANT OPTION;

--- SQL operation complete.


> Cannot create comment on HBASE table
> 
>
> Key: TRAFODION-3084
> URL: https://issues.apache.org/jira/browse/TRAFODION-3084
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: shaoyong.li
>Assignee: shaoyong.li
>Priority: Major
>
> I found I cannot direct create comment on hbase table. 
>  SQL>comment on table hbase."_CELL_"."cdr" is 'test'
> ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
> [2018-05-14 15:55:40]
> But, after doing update statistics on hbase table successfully, comment 
> statement runs successfully on hbase table.
> SQL>update statistics for table hbase."_CELL_"."cdr" on every column;
> — SQL operation complete.
> SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';
> — SQL operation complete.
> SQL>showddl hbase."_CELL_"."cdr";
> /*
>  CREATE TABLE HBASE."_CELL_"."cdr"
>    (
>      ROW_ID VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
>    NOT SERIALIZED
>    , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
>    COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
>    , PRIMARY KEY (ROW_ID ASC)
>    )
>  ;
>  */
> /* HBase DDL */
>  CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')
> REGISTER /*INTERNAL*/

[jira] [Created] (TRAFODION-3084) Cannot create comment on HBASE table

2018-05-24 Thread shaoyong.li (JIRA)

shaoyong.li created TRAFODION-3084:
--

 Summary: Cannot create comment on HBASE table
 Key: TRAFODION-3084
 URL: https://issues.apache.org/jira/browse/TRAFODION-3084
 Project: Apache Trafodion
  Issue Type: Bug
Reporter: shaoyong.li
Assignee: shaoyong.li


I found I cannot direct create comment on hbase table. 
SQL>comment on table hbase."_CELL_"."cdr" is 'test';

*** ERROR[1389] Object HBASE."_CELL_"."cdr" does not exist in Trafodion. 
[2018-05-14 15:55:40]


But, after doing update statistics on hbase table successfully, comment 
statement runs successfully on hbase table.

SQL>update statistics for table hbase."_CELL_"."cdr" on every column;

--- SQL operation complete.

SQL>comment on table hbase."_CELL_"."cdr" is 'test cdr';

--- SQL operation complete.

SQL>showddl hbase."_CELL_"."cdr";


/*
CREATE TABLE HBASE."_CELL_"."cdr"
  (
    ROW_ID VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_FAMILY VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_NAME VARCHAR(100) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , COL_TIMESTAMP LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
  NOT SERIALIZED
  , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591
  COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED
  , PRIMARY KEY (ROW_ID ASC)
  )
;
*/

/* HBase DDL */
CREATE HBASE TABLE cdr ( COLUMN FAMILY '#1')

REGISTER /*INTERNAL*/ HBASE TABLE cdr;
/* ObjectUID = 6735857105763057363 */

COMMENT ON TABLE HBASE."_CELL_"."cdr" IS 'test cdr' ;

-- GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON HBASE."_CELL_"."cdr" TO 
DB__HBASEROLE WITH GRANT OPTION;

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16488595#comment-16488595
 ] 

ASF GitHub Bot commented on TRAFODION-3070:
---

GitHub user zlei929 opened a pull request:

https://github.com/apache/trafodion/pull/1578

[TRAFODION-3070] we cannot comment on native hive table.



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/zlei929/trafodion master

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/trafodion/pull/1578.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #1578


commit c24c712f926b99a38a55e14f6ecdff282525b124
Author: zlei929 
Date:   2018-05-23T03:45:23Z

[TRAFODION-3070] we cannot comment on native hive table.




> Cannot create comment on HIVE table
> ---
>
> Key: TRAFODION-3070
> URL: https://issues.apache.org/jira/browse/TRAFODION-3070
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: any
>Reporter: zhang.lei
>Assignee: zhang.lei
>Priority: Major
> Fix For: any
>
>
> I cannot create comment on HIVE table.
> SQL>comment on table hive.hive.test01 is 'test';
>   ---ERROR[1389] Object HIVE.HIVE.TEST01 does not exist in Trafodion. 
> [2018-05-14 15:51:31]
> Then I create an external table in trafci for the hive table.
> SQL>create external table test01(a largeint,b varchar(4), c varchar(4)) for 
> hive.hive.test01;
> — SQL operation complete.
> And I found I can create comment on the external table.
> SQL>comment on table "__HV_HIVE__".test01 is 'test';
> — SQL operation complete.
> SQL>showddl "__HV_HIVE__".test01;
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
>  ;
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> After that, I try to create comment on the HIVE table.
>  The comment statement completes and I check ddls of the HIVE table.
>  But the comment 'test0102' doesn't appear in the ddl.
>  And comment statement are in front of the semicolon that is the end sign for 
> external table ddl.
> SQL>comment on table hive.hive.test01 is 'test0102';
> — SQL operation complete.
> SQL>showddl hive.hive.test01;
> /* Hive DDL */
>  CREATE TABLE DEFAULT.TEST01
>    (
>  A bigint
>    , B char(4)
>    , C char(4)
>    )
>    stored as textfile
>  ;
> /* Trafodion DDL */
> REGISTER /*INTERNAL*/ HIVE TABLE HIVE.HIVE.TEST01;
>  /* ObjectUID = 1137319817757950657 */
> CREATE EXTERNAL TABLE TEST01
>    (
>  A LARGEINT DEFAULT NULL NOT SERIALIZED
>    , B VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    , C VARCHAR(4) CHARACTER SET ISO88591 COLLATE
>    DEFAULT DEFAULT NULL NOT SERIALIZED
>    )
>    FOR HIVE.HIVE.TEST01
> COMMENT ON TABLE TRAFODION."__HV_HIVE__".TEST01 IS 'test' ;
> ;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2872) Adjust notification file to reflect 2018

2018-05-24 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits closed TRAFODION-2872.
---
Resolution: Fixed

taken care of by the community..

> Adjust notification file to reflect 2018
> 
>
> Key: TRAFODION-2872
> URL: https://issues.apache.org/jira/browse/TRAFODION-2872
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: documentation, website
>Reporter: Pierre Smits
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2862) Remove incubating from images

2018-05-24 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits closed TRAFODION-2862.
---
Resolution: Fixed

taken care of by the community

> Remove incubating from images
> -
>
> Key: TRAFODION-2862
> URL: https://issues.apache.org/jira/browse/TRAFODION-2862
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: images
>Reporter: Pierre Smits
>Priority: Critical
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2861) Remove incubating reference(s) from code base

2018-05-24 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits closed TRAFODION-2861.
---

take care of by the community

> Remove incubating reference(s) from code base
> -
>
> Key: TRAFODION-2861
> URL: https://issues.apache.org/jira/browse/TRAFODION-2861
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: documentation, website
>Reporter: Pierre Smits
>Priority: Major
> Fix For: 2.3
>
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2859) Remove incubating reference(s) from website

2018-05-24 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits closed TRAFODION-2859.
---
Resolution: Fixed

Taken care of by the community shortly after graduation

> Remove incubating reference(s) from website
> ---
>
> Key: TRAFODION-2859
> URL: https://issues.apache.org/jira/browse/TRAFODION-2859
> Project: Apache Trafodion
>  Issue Type: Sub-task
>  Components: website
>Reporter: Pierre Smits
>Priority: Critical
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2858) Graduated Project

2018-05-24 Thread Pierre Smits (JIRA)


 [ 
https://issues.apache.org/jira/browse/TRAFODION-2858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits closed TRAFODION-2858.
---
Resolution: Fixed

Taken care of by the community shortly after graduation.

> Graduated Project
> -
>
> Key: TRAFODION-2858
> URL: https://issues.apache.org/jira/browse/TRAFODION-2858
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: documentation, website
>Reporter: Pierre Smits
>Assignee: Pierre Smits
>Priority: Critical
>
> On December 20th, 2017 the board of the ASF passed the resolution to graduate 
> the project from incubating and establish it as a top level project.
> All references (except the historical notifications, of course) in our 
> products need to be removed.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3082) Add populate-option for CREATE INDEX Statement and fix typos in Trafodion SQL Reference Manual

2018-05-24 Thread ASF GitHub Bot (JIRA)


[ 
https://issues.apache.org/jira/browse/TRAFODION-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16488517#comment-16488517
 ] 

ASF GitHub Bot commented on TRAFODION-3082:
---

Github user liuyu000 commented on a diff in the pull request:

https://github.com/apache/trafodion/pull/1575#discussion_r190479988
  
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -1755,6 +1760,23 @@ for the first column, the values in the second 
column are used to order the rows
 rows occur in a non-unique index, their order is based on the sequence 
specified for the columns of the key of the
 underlying table. For ordering (but not for other purposes), nulls are 
greater than other values.
 
+* `populate-option`
+
+** `NO POPULATE`
++
+specifies that the index is not to be populated when it is created. 
++
+The index’s partition(s) are created, but no data is written to the index, 
and it is marked “offline”. You can drop an offline index with the DROP INDEX 
statement. 
+The DROP TABLE statement also drops offline indexes of the specified 
table. 
+DML statements have no effect on offline indexes. 
++
+If an index is created with the intention of using it for a constraint, it 
must be populated before creating the constraint. 
+You can populate an offline index and remove its offline designation by 
using the POPULATE INDEX utility.
+
+** `POPULATE`
++
+specifies that the index is to be created and populated. 
--- End diff --

Yes, thanks Dave, I've added it ⭐️ 


> Add *populate-option* for *CREATE INDEX Statement* and fix typos in 
> *Trafodion SQL Reference Manual*
> 
>
> Key: TRAFODION-3082
> URL: https://issues.apache.org/jira/browse/TRAFODION-3082
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-3084) Cannot create comment on HBASE table

[jira] [Commented] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

[jira] [Created] (TRAFODION-3086) Traf support for DDL operations directly on Hive objects

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

[jira] [Commented] (TRAFODION-3084) Cannot create comment on HBASE table

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

[jira] [Commented] (TRAFODION-3082) Add populate-option for CREATE INDEX Statement and fix typos in Trafodion SQL Reference Manual

[jira] [Resolved] (TRAFODION-3083) Trafodion compiles fail on CentOS7

[jira] [Commented] (TRAFODION-3083) Trafodion compiles fail on CentOS7

[jira] [Commented] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

[jira] [Created] (TRAFODION-3085) Add Examples for CONTROL QUERY DEFAULT Statement in Trafodion SQL Reference Manual

[jira] [Updated] (TRAFODION-3084) Cannot create comment on HBASE table

[jira] [Created] (TRAFODION-3084) Cannot create comment on HBASE table

[jira] [Commented] (TRAFODION-3070) Cannot create comment on HIVE table

[jira] [Closed] (TRAFODION-2872) Adjust notification file to reflect 2018

[jira] [Closed] (TRAFODION-2862) Remove incubating from images

[jira] [Closed] (TRAFODION-2861) Remove incubating reference(s) from code base

[jira] [Closed] (TRAFODION-2859) Remove incubating reference(s) from website

[jira] [Closed] (TRAFODION-2858) Graduated Project

[jira] [Commented] (TRAFODION-3082) Add populate-option for CREATE INDEX Statement and fix typos in Trafodion SQL Reference Manual

21 matches

Site Navigation

Mail list logo

Footer information