[jira] [Assigned] (TRAFODION-2493) to_char with format 'MONTH DD, YYYY, HH:MI' is wrong
[ https://issues.apache.org/jira/browse/TRAFODION-2493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2493: --- Assignee: Yang, Yongfeng (was: liu ming) > to_char with format 'MONTH DD, , HH:MI' is wrong > > > Key: TRAFODION-2493 > URL: https://issues.apache.org/jira/browse/TRAFODION-2493 > Project: Apache Trafodion > Issue Type: Bug > Components: dev-environment >Affects Versions: 2.0-incubating >Reporter: Yuan Liu >Assignee: Yang, Yongfeng > > SQL>select to_char(current_timestamp, 'MONTH DD, , HH:MI') from > (values(1)); > (EXPR) > - > February 21, 2017, 17:29: > --- 1 row(s) selected. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Assigned] (TRAFODION-2483) Trafodion treat '\' as NULL in hive table
[ https://issues.apache.org/jira/browse/TRAFODION-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2483: --- Assignee: Yang, Yongfeng (was: liu ming) > Trafodion treat '\' as NULL in hive table > - > > Key: TRAFODION-2483 > URL: https://issues.apache.org/jira/browse/TRAFODION-2483 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: Yang, Yongfeng > > If the source data in a hive table have '\', it will be mistakenly treated as > NULL value ('\N'). > Not correct string comparing inside > ExHdfsScanTcb::extractAndTransformAsciiSourceToSqlRow -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Assigned] (TRAFODION-2494) support listagg function
[ https://issues.apache.org/jira/browse/TRAFODION-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2494: --- Assignee: taian.wei > support listagg function > > > Key: TRAFODION-2494 > URL: https://issues.apache.org/jira/browse/TRAFODION-2494 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming >Assignee: taian.wei > > to simulate Oracle's listagg function. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (TRAFODION-2494) support listagg function
liu ming created TRAFODION-2494: --- Summary: support listagg function Key: TRAFODION-2494 URL: https://issues.apache.org/jira/browse/TRAFODION-2494 Project: Apache Trafodion Issue Type: Bug Reporter: liu ming to simulate Oracle's listagg function. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Assigned] (TRAFODION-2493) to_char with format 'MONTH DD, YYYY, HH:MI' is wrong
[ https://issues.apache.org/jira/browse/TRAFODION-2493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2493: --- Assignee: liu ming > to_char with format 'MONTH DD, , HH:MI' is wrong > > > Key: TRAFODION-2493 > URL: https://issues.apache.org/jira/browse/TRAFODION-2493 > Project: Apache Trafodion > Issue Type: Bug > Components: dev-environment >Affects Versions: 2.0-incubating >Reporter: Yuan Liu >Assignee: liu ming > > SQL>select to_char(current_timestamp, 'MONTH DD, , HH:MI') from > (values(1)); > (EXPR) > - > February 21, 2017, 17:29: > --- 1 row(s) selected. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (TRAFODION-2486) Add Identity Column
[ https://issues.apache.org/jira/browse/TRAFODION-2486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liu Yu updated TRAFODION-2486: -- Fix Version/s: 2.1-incubating > Add Identity Column > --- > > Key: TRAFODION-2486 > URL: https://issues.apache.org/jira/browse/TRAFODION-2486 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu > Fix For: 2.1-incubating > > -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (TRAFODION-2419) Update Trafodion SQL Manual: GRANT Statement
[ https://issues.apache.org/jira/browse/TRAFODION-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liu Yu updated TRAFODION-2419: -- Fix Version/s: 2.1-incubating > Update Trafodion SQL Manual: GRANT Statement > > > Key: TRAFODION-2419 > URL: https://issues.apache.org/jira/browse/TRAFODION-2419 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu >Priority: Minor > Fix For: 2.1-incubating > > -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Assigned] (TRAFODION-2055) Automate Kerberos ticket expiration and renewal for a cluster
[ https://issues.apache.org/jira/browse/TRAFODION-2055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roberta Marton reassigned TRAFODION-2055: - Assignee: Roberta Marton > Automate Kerberos ticket expiration and renewal for a cluster > - > > Key: TRAFODION-2055 > URL: https://issues.apache.org/jira/browse/TRAFODION-2055 > Project: Apache Trafodion > Issue Type: Sub-task > Components: sql-security >Reporter: Roberta Marton >Assignee: Roberta Marton > Fix For: 1.1 (pre-incubation) > > > Today, we support a separate Kerberos ticket on each node. When it expires, > the customer has to perform a manual task to renew it. We need an automated > way to perform this operation. There are some options: > Today, a ticket will be renewed until all renewals have been performed. If > there are no more renewals, the ticket expires. Trafodion will not work > until the ticket is reinited. > One option would be to reinit the ticket after all the renewals are used up. > Another option would be to periodically check for ticket expiration. When a > ticket is ready to expire, notify the system administrator. It is then up to > the administrator to renew the ticket(s). > We could provide a tool that would periodically recreate trafodion tickets. > This could be run by the administrator at time that would not affect running > jobs. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Work started] (TRAFODION-2055) Automate Kerberos ticket expiration and renewal for a cluster
[ https://issues.apache.org/jira/browse/TRAFODION-2055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-2055 started by Roberta Marton. - > Automate Kerberos ticket expiration and renewal for a cluster > - > > Key: TRAFODION-2055 > URL: https://issues.apache.org/jira/browse/TRAFODION-2055 > Project: Apache Trafodion > Issue Type: Sub-task > Components: sql-security >Reporter: Roberta Marton >Assignee: Roberta Marton > Fix For: 1.1 (pre-incubation) > > > Today, we support a separate Kerberos ticket on each node. When it expires, > the customer has to perform a manual task to renew it. We need an automated > way to perform this operation. There are some options: > Today, a ticket will be renewed until all renewals have been performed. If > there are no more renewals, the ticket expires. Trafodion will not work > until the ticket is reinited. > One option would be to reinit the ticket after all the renewals are used up. > Another option would be to periodically check for ticket expiration. When a > ticket is ready to expire, notify the system administrator. It is then up to > the administrator to renew the ticket(s). > We could provide a tool that would periodically recreate trafodion tickets. > This could be run by the administrator at time that would not affect running > jobs. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2481) Update new installers in provisioning doc
[ https://issues.apache.org/jira/browse/TRAFODION-2481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15877005#comment-15877005 ] ASF GitHub Bot commented on TRAFODION-2481: --- GitHub user svarnau opened a pull request: https://github.com/apache/incubator-trafodion/pull/974 [TRAFODION-2481] Improve ambari section of provisioning guide Add small screen caps to better illustrate ambari integration. Fix a couple of typos in project-name macros, thanks to Anuradha's review. Fix a bug in the ambari integration code, found by exercising steps in the doc. You can merge this pull request into a Git repository by running: $ git pull https://github.com/svarnau/incubator-trafodion doc2481 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/974.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 #974 commit 1ce7665ed41e8ceb01efa8761f1d76d06d4c487c Author: Steve VarnauDate: 2017-02-21T23:07:54Z [TRAFODION-2481] Improve ambari section of provisioning guide Add small screen caps to better illustrate ambari integration. Fix a couple of typos in project-name macros, thanks to Anuradha's review. Fix a bug in the ambari integration code, found by exercising steps in the doc. > Update new installers in provisioning doc > - > > Key: TRAFODION-2481 > URL: https://issues.apache.org/jira/browse/TRAFODION-2481 > Project: Apache Trafodion > Issue Type: Improvement > Components: documentation >Affects Versions: 2.1-incubating >Reporter: Steve Varnau >Assignee: Steve Varnau > -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2235) Enhance node failure detection and coordination
[ https://issues.apache.org/jira/browse/TRAFODION-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15876862#comment-15876862 ] ASF GitHub Bot commented on TRAFODION-2235: --- Github user trinakrug commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/958#discussion_r102333551 --- Diff: core/sqf/monitor/linux/zclient.cxx --- @@ -472,6 +469,65 @@ void CZClient::CheckCluster( void ) TRACE_EXIT; } +void CZClient::CheckMyZNode( void ) +{ +const char method_name[] = "CZClient::CheckMyZNode"; +TRACE_ENTRY; + +int zerr; +struct timespec currentTime; + +if ( IsCheckCluster() ) +{ +if (resetMyZNodeFailedTime_) +{ +resetMyZNodeFailedTime_ = false; +clock_gettime(CLOCK_REALTIME, _); +myZNodeFailedTime_.tv_sec += (GetSessionTimeout() * 2); +if (trace_settings & (TRACE_INIT | TRACE_RECOVERY)) +{ +trace_printf( "%s@%d" " - Resetting MyZnode Fail Time %ld(secs)\n" +, method_name, __LINE__ +, myZNodeFailedTime_.tv_sec ); +} +} +if ( ! IsZNodeExpired( Node_name, zerr ) ) +{ +if ( zerr == ZCONNECTIONLOSS || zerr == ZOPERATIONTIMEOUT ) +{ +// Ignore transient errors with the quorum. +// However, if longer than the session +// timeout, handle it as a hard error. +clock_gettime(CLOCK_REALTIME, ); +if (currentTime.tv_sec > myZNodeFailedTime_.tv_sec) --- End diff -- Sounds good Zalo! Thumbs up from me then! > Enhance node failure detection and coordination > --- > > Key: TRAFODION-2235 > URL: https://issues.apache.org/jira/browse/TRAFODION-2235 > Project: Apache Trafodion > Issue Type: Bug > Components: foundation, installer >Affects Versions: 2.1-incubating >Reporter: Gonzalo E Correa >Assignee: Gonzalo E Correa > > Certain server and network failures are not detected by the monitor processes > which cause a safety net failure detection mechanism to trigger in all > Trafodion nodes. This safety net mechanism is controlled by the environment > variable SQ_MON_SYNC_TIMEOUT currently set at 15 minutes. > This JIRA is to enhance the node failure mechanism in the Trafodion > foundation components, specifically the monitor process, to detect a > non-responsive node and handle it as a node down condition when a > configurable timeout event is detected prior to the safety net failure > mechanism described above. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Resolved] (TRAFODION-1586) Add support to create an external Trafodion table and map it to a native HBase table
[ https://issues.apache.org/jira/browse/TRAFODION-1586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sandhya Sundaresan resolved TRAFODION-1586. --- Resolution: Fixed > Add support to create an external Trafodion table and map it to a native > HBase table > > > Key: TRAFODION-1586 > URL: https://issues.apache.org/jira/browse/TRAFODION-1586 > Project: Apache Trafodion > Issue Type: New Feature >Reporter: Anoop Sharma >Assignee: Anoop Sharma >Priority: Minor > > Proposal to create an external table in Trafodion metadata and map it to an > existing HBase table. > Listed below are proposed syntax and semantics rules for this support. > Proposed Syntax: > create external table T (…column definitions…) map to hbase table T; > this will create a Trafodion table in metadata with columns specified > in ‘column definitions’ and > map that definition to an externally created native HBase table T. > alter table T add column b; > alter table T drop column b; > will add and drop column ‘b’ from Trafodion metadata. Underlying mapped > HBase table will not be affected. > drop table T; > will drop external table T from Trafodion metadata. Underlying mapped > HBase table will not be affected. > Semantics: > If table T is specified in a DDL or DML statement without an explicit > schema (like: drop table T, or select * from T >,or create table Tlike like T), > then it will be first searched as a regular table in default regular schema. > If not found, then it will be searched as a mapped table. > So a regular table T will take precedence over a mapped table T. >It is recommended that one does not create a regular table and a mapped > table with the same name to avoid confusion. > Restrictions: > To limit the initial scope of this work, there will be some restrictions. > Some of these may be lifted > at a later time. > insert, update and delete statements on mapped tables will not be > initially supported. > a mapped table cannot be aligned format table > A primary key clause must be specified > external and hbase mapped table names must be the same > All non-primarykey and non-nullable columns must have a default value. > This is needed to handle missing values >in the underlying HBase table. > creation of a Trafodion index on a mapped table will not be supported > This proposal will be updated with additional syntax and semantics rules > going forward. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2235) Enhance node failure detection and coordination
[ https://issues.apache.org/jira/browse/TRAFODION-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15876742#comment-15876742 ] ASF GitHub Bot commented on TRAFODION-2235: --- Github user trinakrug commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/958#discussion_r102274683 --- Diff: core/sqf/monitor/linux/zclient.cxx --- @@ -472,6 +469,65 @@ void CZClient::CheckCluster( void ) TRACE_EXIT; } +void CZClient::CheckMyZNode( void ) +{ +const char method_name[] = "CZClient::CheckMyZNode"; +TRACE_ENTRY; + +int zerr; +struct timespec currentTime; + +if ( IsCheckCluster() ) +{ +if (resetMyZNodeFailedTime_) +{ +resetMyZNodeFailedTime_ = false; +clock_gettime(CLOCK_REALTIME, _); +myZNodeFailedTime_.tv_sec += (GetSessionTimeout() * 2); +if (trace_settings & (TRACE_INIT | TRACE_RECOVERY)) +{ +trace_printf( "%s@%d" " - Resetting MyZnode Fail Time %ld(secs)\n" +, method_name, __LINE__ +, myZNodeFailedTime_.tv_sec ); +} +} +if ( ! IsZNodeExpired( Node_name, zerr ) ) +{ +if ( zerr == ZCONNECTIONLOSS || zerr == ZOPERATIONTIMEOUT ) +{ +// Ignore transient errors with the quorum. +// However, if longer than the session +// timeout, handle it as a hard error. +clock_gettime(CLOCK_REALTIME, ); +if (currentTime.tv_sec > myZNodeFailedTime_.tv_sec) --- End diff -- If resetMyZNodeFailedTime_ is true, then this if statement will always evaluate to true. Just verifying that is the desired outcome. > Enhance node failure detection and coordination > --- > > Key: TRAFODION-2235 > URL: https://issues.apache.org/jira/browse/TRAFODION-2235 > Project: Apache Trafodion > Issue Type: Bug > Components: foundation, installer >Affects Versions: 2.1-incubating >Reporter: Gonzalo E Correa >Assignee: Gonzalo E Correa > > Certain server and network failures are not detected by the monitor processes > which cause a safety net failure detection mechanism to trigger in all > Trafodion nodes. This safety net mechanism is controlled by the environment > variable SQ_MON_SYNC_TIMEOUT currently set at 15 minutes. > This JIRA is to enhance the node failure mechanism in the Trafodion > foundation components, specifically the monitor process, to detect a > non-responsive node and handle it as a node down condition when a > configurable timeout event is detected prior to the safety net failure > mechanism described above. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2482) documentation for python installer
[ https://issues.apache.org/jira/browse/TRAFODION-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875942#comment-15875942 ] ASF GitHub Bot commented on TRAFODION-2482: --- GitHub user mkby opened a pull request: https://github.com/apache/incubator-trafodion/pull/973 [TRAFODION-2482] documentation for python installer You can merge this pull request into a Git repository by running: $ git pull https://github.com/mkby/incubator-trafodion r21-2482 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/973.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 #973 commit c155bfaecfcb93755e401ee0551e32b50ec7b370 Author: EasonDate: 2017-02-21T09:29:42Z [TRAFODION-2482] documentation for python installer > documentation for python installer > -- > > Key: TRAFODION-2482 > URL: https://issues.apache.org/jira/browse/TRAFODION-2482 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Eason Zhang >Assignee: Eason Zhang > > update documentation for python installer -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2480) monitor should not check hostname strictly
[ https://issues.apache.org/jira/browse/TRAFODION-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875691#comment-15875691 ] ASF GitHub Bot commented on TRAFODION-2480: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/956 > monitor should not check hostname strictly > -- > > Key: TRAFODION-2480 > URL: https://issues.apache.org/jira/browse/TRAFODION-2480 > Project: Apache Trafodion > Issue Type: Bug >Reporter: Eason Zhang >Assignee: Eason Zhang > > Monitor should not consider short hostname and FQDN as different names, both > short/full hostname should be accepted. (cherry pick this fix from esgynDB) -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (TRAFODION-2493) to_char with format 'MONTH DD, YYYY, HH:MI' is wrong
Yuan Liu created TRAFODION-2493: --- Summary: to_char with format 'MONTH DD, , HH:MI' is wrong Key: TRAFODION-2493 URL: https://issues.apache.org/jira/browse/TRAFODION-2493 Project: Apache Trafodion Issue Type: Bug Components: dev-environment Affects Versions: 2.0-incubating Reporter: Yuan Liu SQL>select to_char(current_timestamp, 'MONTH DD, , HH:MI') from (values(1)); (EXPR) - February 21, 2017, 17:29: --- 1 row(s) selected. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (TRAFODION-2405) update sql reference manual about WITH clause syntax
[ https://issues.apache.org/jira/browse/TRAFODION-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15875602#comment-15875602 ] liu ming commented on TRAFODION-2405: - Trafodion can support ANSI SQL with-clause, so the documentation need to sync with it. Need to add description about syntax and usage examples, etc. > update sql reference manual about WITH clause syntax > > > Key: TRAFODION-2405 > URL: https://issues.apache.org/jira/browse/TRAFODION-2405 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: Liu Yu > > update syntax support of WITH clause -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Assigned] (TRAFODION-2405) update sql reference manual about WITH clause syntax
[ https://issues.apache.org/jira/browse/TRAFODION-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming reassigned TRAFODION-2405: --- Assignee: Liu Yu (was: liu ming) > update sql reference manual about WITH clause syntax > > > Key: TRAFODION-2405 > URL: https://issues.apache.org/jira/browse/TRAFODION-2405 > Project: Apache Trafodion > Issue Type: Improvement >Reporter: liu ming >Assignee: Liu Yu > > update syntax support of WITH clause -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Resolved] (TRAFODION-2412) Add CREATE/DROP/ALTER SEQUENCE Statement + Update CREATE INDEX Statement
[ https://issues.apache.org/jira/browse/TRAFODION-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liu ming resolved TRAFODION-2412. - Resolution: Fixed > Add CREATE/DROP/ALTER SEQUENCE Statement + Update CREATE INDEX Statement > > > Key: TRAFODION-2412 > URL: https://issues.apache.org/jira/browse/TRAFODION-2412 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: liu ming >Assignee: Liu Yu > > add descriptions about how to use SEQUENCE and how to use IDENTITY column. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Resolved] (TRAFODION-2486) Add Identity Column
[ https://issues.apache.org/jira/browse/TRAFODION-2486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liu Yu resolved TRAFODION-2486. --- Resolution: Fixed > Add Identity Column > --- > > Key: TRAFODION-2486 > URL: https://issues.apache.org/jira/browse/TRAFODION-2486 > Project: Apache Trafodion > Issue Type: Documentation >Reporter: Liu Yu >Assignee: Liu Yu > -- This message was sent by Atlassian JIRA (v6.3.15#6346)