[jira] [Comment Edited] (TRAFODION-1963) Create index with delimited name fails if table has data

2016-05-02 Thread David Wayne Birdsall (JIRA) 

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

David Wayne Birdsall edited comment on TRAFODION-1963 at 5/3/16 4:20 AM:
-

Is this the same bug as in https://issues.apache.org/jira/browse/TRAFODION-1938?




was (Author: davebirdsall):
Is this the same bug as in JIRA Trafodion-1938?


> Create index with delimited name fails if table has data
> 
>
> Key: TRAFODION-1963
> URL: https://issues.apache.org/jira/browse/TRAFODION-1963
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.3-incubating
>Reporter: Suresh Subbiah
>Assignee: Suresh Subbiah
>
> >>create table t1 (a int, b int) ;
> --- SQL operation complete.
> >>insert into t1 values (1,1),(2,2) ;
> --- 2 row(s) inserted.
> >>create index "i1" on t1(b) ;
> *** ERROR[8448] Unable to access Hbase interface. Call to 
> ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
> Cause: 
> java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
> User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
> [a-zA-Z_0-9-.]: TRAFODION.SEABASE."i1"
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
> org.apache.hadoop.hbase.TableName.(TableName.java:322)
> org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
> org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
> org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
> org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
> .
> *** ERROR[1081] Loading of index TRAFODION.SEABASE."i1" failed unexpectedly.
> --- SQL operation failed with errors.
> >>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1963) Create index with delimited name fails if table has data

2016-05-02 Thread David Wayne Birdsall (JIRA) 

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

David Wayne Birdsall commented on TRAFODION-1963:
-

Is this the same bug as in JIRA Trafodion-1938?


> Create index with delimited name fails if table has data
> 
>
> Key: TRAFODION-1963
> URL: https://issues.apache.org/jira/browse/TRAFODION-1963
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.3-incubating
>Reporter: Suresh Subbiah
>Assignee: Suresh Subbiah
>
> >>create table t1 (a int, b int) ;
> --- SQL operation complete.
> >>insert into t1 values (1,1),(2,2) ;
> --- 2 row(s) inserted.
> >>create index "i1" on t1(b) ;
> *** ERROR[8448] Unable to access Hbase interface. Call to 
> ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
> Cause: 
> java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
> User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
> [a-zA-Z_0-9-.]: TRAFODION.SEABASE."i1"
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
> org.apache.hadoop.hbase.TableName.(TableName.java:322)
> org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
> org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
> org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
> org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
> .
> *** ERROR[1081] Loading of index TRAFODION.SEABASE."i1" failed unexpectedly.
> --- SQL operation failed with errors.
> >>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1963) Create index with delimited name fails if table has data

2016-05-02 Thread ASF GitHub Bot (JIRA) 

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

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

GitHub user sureshsubbiah opened a pull request:

https://github.com/apache/incubator-trafodion/pull/460

TRAFODION-1963 Create index with delimited name fails if table has data

Delimited name was being sent during load complete.

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

$ git pull https://github.com/sureshsubbiah/incubator-trafodion 
TRAFODION-1963

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

https://github.com/apache/incubator-trafodion/pull/460.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 #460


commit 03e761498f20e14e120eb350af0c74ecccb2836b
Author: Suresh Subbiah 
Date:   2016-05-03T04:05:33Z

Fix for JIRA-1963
Delimited name was being sent during load complete.




> Create index with delimited name fails if table has data
> 
>
> Key: TRAFODION-1963
> URL: https://issues.apache.org/jira/browse/TRAFODION-1963
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.3-incubating
>Reporter: Suresh Subbiah
>Assignee: Suresh Subbiah
>
> >>create table t1 (a int, b int) ;
> --- SQL operation complete.
> >>insert into t1 values (1,1),(2,2) ;
> --- 2 row(s) inserted.
> >>create index "i1" on t1(b) ;
> *** ERROR[8448] Unable to access Hbase interface. Call to 
> ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
> Cause: 
> java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
> User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
> [a-zA-Z_0-9-.]: TRAFODION.SEABASE."i1"
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
> org.apache.hadoop.hbase.TableName.(TableName.java:322)
> org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
> org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
> org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
> org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
> .
> *** ERROR[1081] Loading of index TRAFODION.SEABASE."i1" failed unexpectedly.
> --- SQL operation failed with errors.
> >>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Assigned] (TRAFODION-1962) Package checking for SLES

2016-05-02 Thread Amanda Moran (JIRA) 

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

Amanda Moran reassigned TRAFODION-1962:
---

Assignee: Amanda Moran

> Package checking for SLES
> -
>
> Key: TRAFODION-1962
> URL: https://issues.apache.org/jira/browse/TRAFODION-1962
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: installer
>Reporter: Amanda Moran
>Assignee: Amanda Moran
>Priority: Minor
>
> In traf_package_setup add package checking for SLES 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (TRAFODION-1965) Enhance how initialize trafodion is done in traf_start

2016-05-02 Thread Amanda Moran (JIRA) 
Amanda Moran created TRAFODION-1965:
---

 Summary: Enhance how initialize trafodion is done in traf_start
 Key: TRAFODION-1965
 URL: https://issues.apache.org/jira/browse/TRAFODION-1965
 Project: Apache Trafodion
  Issue Type: Improvement
  Components: installer
Reporter: Amanda Moran
Assignee: Amanda Moran
Priority: Minor


Should be a 3 step process. 

step 1:  initialize trafodion.
   if this returns error 1392 (“traf is already initialized”), then move to 
step 2.
   if this doesn’t return an error, then we are done. No need to upgrade.
   Otherwise abort.
step 2:  get version of metadata;
  if this returns status “Metadata is current”, then we are done.
  Otherwise move to step 3.
step 3: initialize trafodion, upgrade;
 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (TRAFODION-1964) Cannot run SPJs after an trafodion upgrade

2016-05-02 Thread Venkat Muthuswamy (JIRA) 
Venkat Muthuswamy created TRAFODION-1964:


 Summary: Cannot run SPJs after an trafodion upgrade 
 Key: TRAFODION-1964
 URL: https://issues.apache.org/jira/browse/TRAFODION-1964
 Project: Apache Trafodion
  Issue Type: Bug
Reporter: Venkat Muthuswamy


The system and user SPJ jar files are now stored under 
$MY_SQROOT/udr/lib/.

The CREATE LIBRARY/ALTER LIBRARY commands use the fully qualified linux 
directory paths (the environment variables are expanded). 

For example, if current trafodion build is installed under 
/home/trafodion/build1, the files are stored under 
/home/trafodion/build1/udr/lib/user1

When the user upgrades and installs a new build, let's say trafodion is 
installed under /home/trafodion/build2. 

If the user removes this old trafodion installation, the libraries and SPJs 
defined using build1 no longer work, because the UDR tries to load the jar file 
from /home/trafodion/build1/udr/lib/user1 folder because that's what is stored 
in the metadata.

Even if the folder exists, any system created library would be pointing to an 
older version of the jar file even though the new install might include fixes 
to the system library jar.

1. Can the CREATE and ALTER LIBRARY commands use relative paths to  something 
like $MY_UDR_ROOT  and not required the fully qualified paths?

2. Can the UDR runtime be modified to look at the relative paths $MY_UDR_ROOT.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1963) Create index with delimited name fails if table has data

2016-05-02 Thread Suresh Subbiah (JIRA) 

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

Suresh Subbiah commented on TRAFODION-1963:
---

This problem is present for delimited tables too.

>>create table "t2" (a int, b int) ;

--- SQL operation complete.
>>load into "t2" select * from t1 ;
Task: LOAD Status: StartedObject: TRAFODION.SEABASE."t2"
Task:  CLEANUP Status: StartedObject: TRAFODION.SEABASE."t2"
Task:  CLEANUP Status: Ended  Object: TRAFODION.SEABASE."t2"
Task:  PREPARATION Status: StartedObject: TRAFODION.SEABASE."t2"
   Rows Processed: 2 
Task:  PREPARATION Status: Ended  ET: 00:00:00.375
Task:  COMPLETION  Status: StartedObject: TRAFODION.SEABASE."t2"

*** ERROR[8448] Unable to access Hbase interface. Call to 
ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
Cause: 
java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
[a-zA-Z_0-9-.]: TRAFODION.SEABASE."t2"
org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
org.apache.hadoop.hbase.TableName.(TableName.java:322)
org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
.

--- 0 row(s) loaded.


> Create index with delimited name fails if table has data
> 
>
> Key: TRAFODION-1963
> URL: https://issues.apache.org/jira/browse/TRAFODION-1963
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.3-incubating
>Reporter: Suresh Subbiah
>Assignee: Suresh Subbiah
>
> >>create table t1 (a int, b int) ;
> --- SQL operation complete.
> >>insert into t1 values (1,1),(2,2) ;
> --- 2 row(s) inserted.
> >>create index "i1" on t1(b) ;
> *** ERROR[8448] Unable to access Hbase interface. Call to 
> ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
> Cause: 
> java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
> User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
> [a-zA-Z_0-9-.]: TRAFODION.SEABASE."i1"
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
> org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
> org.apache.hadoop.hbase.TableName.(TableName.java:322)
> org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
> org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
> org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
> org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
> .
> *** ERROR[1081] Loading of index TRAFODION.SEABASE."i1" failed unexpectedly.
> --- SQL operation failed with errors.
> >>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (TRAFODION-1963) Create index with delimited name fails if table has data

2016-05-02 Thread Suresh Subbiah (JIRA) 
Suresh Subbiah created TRAFODION-1963:
-

 Summary: Create index with delimited name fails if table has data
 Key: TRAFODION-1963
 URL: https://issues.apache.org/jira/browse/TRAFODION-1963
 Project: Apache Trafodion
  Issue Type: Bug
  Components: sql-general
Affects Versions: 1.3-incubating
Reporter: Suresh Subbiah
Assignee: Suresh Subbiah


>>create table t1 (a int, b int) ;

--- SQL operation complete.
>>insert into t1 values (1,1),(2,2) ;

--- 2 row(s) inserted.
>>create index "i1" on t1(b) ;

*** ERROR[8448] Unable to access Hbase interface. Call to 
ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). 
Cause: 
java.lang.IllegalArgumentException: Illegal character code:34, <"> at 18. 
User-space table qualifiers can only contain 'alphanumeric characters': i.e. 
[a-zA-Z_0-9-.]: TRAFODION.SEABASE."i1"
org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:196)
org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
org.apache.hadoop.hbase.TableName.(TableName.java:322)
org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:358)
org.apache.hadoop.hbase.TableName.valueOf(TableName.java:445)
org.apache.hadoop.hbase.client.HTable.(HTable.java:143)
org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
.

*** ERROR[1081] Loading of index TRAFODION.SEABASE."i1" failed unexpectedly.

--- SQL operation failed with errors.
>>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1874) find a new way to check CLUSTER environment instead of checking pdsh

2016-05-02 Thread Amanda Moran (JIRA) 

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

Amanda Moran commented on TRAFODION-1874:
-

There are changes that need to be made in the installer as well. Please let me 
know when to add those changes so we can coordinate :)

Thanks! 

> find a new way to check CLUSTER environment instead of checking pdsh
> 
>
> Key: TRAFODION-1874
> URL: https://issues.apache.org/jira/browse/TRAFODION-1874
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: foundation, installer
>Reporter: liu ming
>Assignee: liu ming
>
> Some Trafodion script need to tell if it is running in a dev workstation or a 
> real cluster, and behave differently.
> Current, some script tell this difference by checking the rpm package pdsh, 
> if it is installed, then the script think it is running on a cluster. 
> PDSH is a public package, and can be installed in a workstation as well. So 
> it is better to find a new testing logic for this purpose.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1955) JNI optimization in Trafodion

2016-05-02 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/459


> JNI optimization in Trafodion 
> --
>
> Key: TRAFODION-1955
> URL: https://issues.apache.org/jira/browse/TRAFODION-1955
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: Selvaganesan Govindarajan
>Assignee: Selvaganesan Govindarajan
>
> ByteArrayList in Trafodion is an expensive class. Removing the use of this 
> class everywhere. Replace its usage with array of byte arrays.
> This class is mainly used in compiler. Hence it is expected to see some 
> improvement with compilation of queries when the tables involved in queries 
> have large number of regions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Created] (TRAFODION-1962) Package checking for SLES

2016-05-02 Thread Amanda Moran (JIRA) 
Amanda Moran created TRAFODION-1962:
---

 Summary: Package checking for SLES
 Key: TRAFODION-1962
 URL: https://issues.apache.org/jira/browse/TRAFODION-1962
 Project: Apache Trafodion
  Issue Type: Bug
  Components: installer
Reporter: Amanda Moran
Priority: Minor


In traf_package_setup add package checking for SLES 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1933) Migrate jdbcT4 and trafci build scripts from Ant to Maven

2016-05-02 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/458


> Migrate jdbcT4 and trafci build scripts from Ant to Maven
> -
>
> Key: TRAFODION-1933
> URL: https://issues.apache.org/jira/browse/TRAFODION-1933
> Project: Apache Trafodion
>  Issue Type: Improvement
>Reporter: Anuradha Hegde
>Assignee: Anuradha Hegde
>
> Currently jdbct4 and trafci uses Ant to build. We need to convert these build 
> scripts to use Maven



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (TRAFODION-1943) Jar file is not uploaded to all nodes after calling the PUT system spj to upload the jar.

2016-05-02 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/453


> Jar file is not uploaded to all nodes after calling the PUT system spj to 
> upload the jar.
> -
>
> Key: TRAFODION-1943
> URL: https://issues.apache.org/jira/browse/TRAFODION-1943
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: connectivity-general
>Reporter: Elaine_WangLing
>Assignee: Kevin Xu
>
> Jar file is not uploaded to all nodes after calling the PUT system spj to 
> upload the jar



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)