[jira] [Reopened] (HAWQ-355) order by problem: sorting varchar column with space is not correct.
[ https://issues.apache.org/jira/browse/HAWQ-355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang reopened HAWQ-355: > order by problem: sorting varchar column with space is not correct. > --- > > Key: HAWQ-355 > URL: https://issues.apache.org/jira/browse/HAWQ-355 > Project: Apache HAWQ > Issue Type: Bug >Reporter: SuperJDC >Assignee: Lei Chang > Fix For: 2.0.0 > > > Firstly, my hawq download from official website: > https://network.pivotal.io/products/pivotal-hdb, a released stable version. > My steps: > DROP TABLE IF EXISTS testorder; > CREATE TABLE testorder( > ss VARCHAR(10) > ) distributed randomly; > INSERT INTO testorder > VALUES ('cc'), ('c c'), ('cc'), > ('aa'), ('a a'), ('ac'), > ('b c'), ('bc'), ('bb'); > SELECT ss FROM testorder > ORDER BY ss; > The result: > aa > a a > ac > bb > bc > b c > cc > cc > c c > It seems that when a colum has a space char, the sorted result would been not > correct. > I followed the document steps and successfully integrated with the ambari. > All of hawq configurations are the default. > Thanks! -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-355) order by problem: sorting varchar column with space is not correct.
[ https://issues.apache.org/jira/browse/HAWQ-355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang resolved HAWQ-355. Resolution: Fixed > order by problem: sorting varchar column with space is not correct. > --- > > Key: HAWQ-355 > URL: https://issues.apache.org/jira/browse/HAWQ-355 > Project: Apache HAWQ > Issue Type: Bug >Reporter: SuperJDC >Assignee: Lei Chang > Fix For: 2.0.0 > > > Firstly, my hawq download from official website: > https://network.pivotal.io/products/pivotal-hdb, a released stable version. > My steps: > DROP TABLE IF EXISTS testorder; > CREATE TABLE testorder( > ss VARCHAR(10) > ) distributed randomly; > INSERT INTO testorder > VALUES ('cc'), ('c c'), ('cc'), > ('aa'), ('a a'), ('ac'), > ('b c'), ('bc'), ('bb'); > SELECT ss FROM testorder > ORDER BY ss; > The result: > aa > a a > ac > bb > bc > b c > cc > cc > c c > It seems that when a colum has a space char, the sorted result would been not > correct. > I followed the document steps and successfully integrated with the ambari. > All of hawq configurations are the default. > Thanks! -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-355) order by problem: sorting varchar column with space is not correct.
[ https://issues.apache.org/jira/browse/HAWQ-355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-355: --- Fix Version/s: (was: backlog) 2.0.0 > order by problem: sorting varchar column with space is not correct. > --- > > Key: HAWQ-355 > URL: https://issues.apache.org/jira/browse/HAWQ-355 > Project: Apache HAWQ > Issue Type: Bug >Reporter: SuperJDC >Assignee: Lei Chang > Fix For: 2.0.0 > > > Firstly, my hawq download from official website: > https://network.pivotal.io/products/pivotal-hdb, a released stable version. > My steps: > DROP TABLE IF EXISTS testorder; > CREATE TABLE testorder( > ss VARCHAR(10) > ) distributed randomly; > INSERT INTO testorder > VALUES ('cc'), ('c c'), ('cc'), > ('aa'), ('a a'), ('ac'), > ('b c'), ('bc'), ('bb'); > SELECT ss FROM testorder > ORDER BY ss; > The result: > aa > a a > ac > bb > bc > b c > cc > cc > c c > It seems that when a colum has a space char, the sorted result would been not > correct. > I followed the document steps and successfully integrated with the ambari. > All of hawq configurations are the default. > Thanks! -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-19) Money type overflow
[ https://issues.apache.org/jira/browse/HAWQ-19?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-19: -- Fix Version/s: (was: backlog) 2.0.0 > Money type overflow > --- > > Key: HAWQ-19 > URL: https://issues.apache.org/jira/browse/HAWQ-19 > Project: Apache HAWQ > Issue Type: Bug > Components: Catalog >Reporter: Feng Tian >Assignee: Ming LI > Fix For: 2.0.0 > > > Use tpch schema, but change l_extendedprice to use MONEY type, run Q1, you > should see negative amounts. > I believe this is due to overflow. > Side mark, postgres 9 money type use 8 bytes and will return correct result. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Reopened] (HAWQ-19) Money type overflow
[ https://issues.apache.org/jira/browse/HAWQ-19?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang reopened HAWQ-19: --- > Money type overflow > --- > > Key: HAWQ-19 > URL: https://issues.apache.org/jira/browse/HAWQ-19 > Project: Apache HAWQ > Issue Type: Bug > Components: Catalog >Reporter: Feng Tian >Assignee: Ming LI > Fix For: backlog > > > Use tpch schema, but change l_extendedprice to use MONEY type, run Q1, you > should see negative amounts. > I believe this is due to overflow. > Side mark, postgres 9 money type use 8 bytes and will return correct result. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-235) HAWQ init report error message on centos7
[ https://issues.apache.org/jira/browse/HAWQ-235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-235: --- Fix Version/s: (was: 2.1.0) 2.0.0 > HAWQ init report error message on centos7 > - > > Key: HAWQ-235 > URL: https://issues.apache.org/jira/browse/HAWQ-235 > Project: Apache HAWQ > Issue Type: Bug > Components: Command Line Tools >Reporter: Zhanwei Wang >Assignee: Radar Lei > Fix For: 2.0.0 > > > {code} > [gpadmin@centos7-namenode hawq-devel]$ hawq init cluster > 20151209:03:02:07:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Prepare > to do 'hawq init' > 20151209:03:02:07:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-You can > check log in /home/gpadmin/hawqAdminLogs/hawq_init_20151209.log > 20151209:03:02:07:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Init hawq > with args: ['init', 'cluster'] > Continue with HAWQ init Yy|Nn (default=N): > > y > 20151209:03:02:08:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Check if > hdfs path is available > 20151209:03:02:08:000292 > hawq_init:centos7-namenode:gpadmin-[WARNING]:-WARNING:'hdfs://centos7-namenode:8020/hawq_default' > does not exist, create it ... > 20151209:03:02:08:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-3 segment > hosts defined > 20151209:03:02:08:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Set > default_segment_num as: 24 > The authenticity of host 'centos7-datanode1 (172.17.0.85)' can't be > established. > ECDSA key fingerprint is 51:84:fc:86:2c:d3:30:0b:06:ac:49:f4:a8:5d:e1:bd. > Are you sure you want to continue connecting (yes/no)? yes > The authenticity of host 'centos7-datanode2 (172.17.0.86)' can't be > established. > ECDSA key fingerprint is 51:84:fc:86:2c:d3:30:0b:06:ac:49:f4:a8:5d:e1:bd. > Are you sure you want to continue connecting (yes/no)? yes > The authenticity of host 'centos7-datanode3 (172.17.0.87)' can't be > established. > ECDSA key fingerprint is 51:84:fc:86:2c:d3:30:0b:06:ac:49:f4:a8:5d:e1:bd. > Are you sure you want to continue connecting (yes/no)? yes > The authenticity of host 'centos7-namenode (172.17.0.84)' can't be > established. > ECDSA key fingerprint is 51:84:fc:86:2c:d3:30:0b:06:ac:49:f4:a8:5d:e1:bd. > Are you sure you want to continue connecting (yes/no)? yes > 20151209:03:02:15:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Start to > init master node: 'centos7-namenode' > 20151209:03:02:23:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Master > init successfully > 20151209:03:02:23:000292 hawq_init:centos7-namenode:gpadmin-[INFO]:-Init > segments in list: ['centos7-datanode1', 'centos7-datanode2', > 'centos7-datanode3'] > .20151209:03:02:32:000292 > hawq_init:centos7-namenode:gpadmin-[INFO]:-/data/hawq-devel/bin/lib/hawq_bash_functions.sh: > line 59: return: Problem in hawq_bash_functions, command 'ifconfig' not > found in COMMAND path. You will need to edit the script named > hawq_bash_functions.sh to properly locate the needed commands > for your platform.: numeric argument required > /data/hawq-devel/bin/lib/hawq_bash_functions.sh: line 59: return: Problem in > hawq_bash_functions, command 'netstat' not found in COMMAND path. > You will need to edit the script named hawq_bash_functions.sh to properly > locate the needed commands for your platform.: numeric > argument required > Host key verification failed. > /data/hawq-devel/bin/lib/hawqinit.sh: line 72: ifconfig: command not found > 20151209:03:02:32:000292 > hawq_init:centos7-namenode:gpadmin-[INFO]:-/data/hawq-devel/bin/lib/hawq_bash_functions.sh: > line 59: return: Problem in hawq_bash_functions, command 'ifconfig' not > found in COMMAND path. You will need to edit the script named > hawq_bash_functions.sh to properly locate the needed commands > for your platform.: numeric argument required > /data/hawq-devel/bin/lib/hawq_bash_functions.sh: line 59: return: Problem in > hawq_bash_functions, command 'netstat' not found in COMMAND path. > You will need to edit the script named hawq_bash_functions.sh to properly > locate the needed commands for your platform.: numeric > argument required > Host key verification failed. > /data/hawq-devel/bin/lib/hawqinit.sh: line 72: ifconfig: command not found > 20151209:03:02:32:000292 > hawq_init:centos7-namenode:gpadmin-[INFO]:-/data/hawq-devel/bin/lib/hawq_bash_functions.sh: > line 59: return: Problem in hawq_bash_functions, command 'ifconfig' not > found in COMMAND path. You will need to edit the script named > hawq_bash_functions.sh to properly locate the needed commands > for your platform.: numeric argument required >
[jira] [Updated] (HAWQ-331) Fix HAWQ Jenkins pullrequest build reporting
[ https://issues.apache.org/jira/browse/HAWQ-331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-331: --- Fix Version/s: (was: 2.0.0) 2.1.0 > Fix HAWQ Jenkins pullrequest build reporting > > > Key: HAWQ-331 > URL: https://issues.apache.org/jira/browse/HAWQ-331 > Project: Apache HAWQ > Issue Type: Task > Components: Build >Reporter: Goden Yao >Assignee: Radar Lei > Fix For: 2.1.0 > > > https://builds.apache.org/job/HAWQ-build-pullrequest/83/console > It has been recently discovered that Jenkins reports SUCCESS even when a > build was actually failed. > *Acceptance Criteria* > 1. No false SUCCESS when it was a failure > 2. Include Installcheck good, unit tests in the build process -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-331) Fix HAWQ Jenkins pullrequest build reporting
[ https://issues.apache.org/jira/browse/HAWQ-331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-331: --- Fix Version/s: (was: 2.1.0) 2.0.0 > Fix HAWQ Jenkins pullrequest build reporting > > > Key: HAWQ-331 > URL: https://issues.apache.org/jira/browse/HAWQ-331 > Project: Apache HAWQ > Issue Type: Task > Components: Build >Reporter: Goden Yao >Assignee: Radar Lei > Fix For: 2.1.0 > > > https://builds.apache.org/job/HAWQ-build-pullrequest/83/console > It has been recently discovered that Jenkins reports SUCCESS even when a > build was actually failed. > *Acceptance Criteria* > 1. No false SUCCESS when it was a failure > 2. Include Installcheck good, unit tests in the build process -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-717) HAWQ hawq ssh-exkeys command should consider the string exactly as its given at the command line prompt
[ https://issues.apache.org/jira/browse/HAWQ-717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-717: --- Fix Version/s: (was: 2.1.0) 2.0.0 > HAWQ hawq ssh-exkeys command should consider the string exactly as its given > at the command line prompt > --- > > Key: HAWQ-717 > URL: https://issues.apache.org/jira/browse/HAWQ-717 > Project: Apache HAWQ > Issue Type: Bug >Affects Versions: 2.0.0 >Reporter: bhuvnesh chaudhary >Assignee: bhuvnesh chaudhary > Fix For: 2.0.0 > > > HAWQ hawq ssh-exkeys command should consider the string exactly as its given > at the command line prompt. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Closed] (HAWQ-726) configure and configure.in are not consistent.
[ https://issues.apache.org/jira/browse/HAWQ-726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Guo closed HAWQ-726. - Resolution: Fixed > configure and configure.in are not consistent. > -- > > Key: HAWQ-726 > URL: https://issues.apache.org/jira/browse/HAWQ-726 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Paul Guo >Assignee: Lei Chang > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-703) Serialize HCatalog Complex Types to plain text (as Hive profile)
[ https://issues.apache.org/jira/browse/HAWQ-703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Oleksandr Diachenko resolved HAWQ-703. -- Resolution: Fixed > Serialize HCatalog Complex Types to plain text (as Hive profile) > > > Key: HAWQ-703 > URL: https://issues.apache.org/jira/browse/HAWQ-703 > Project: Apache HAWQ > Issue Type: New Feature > Components: Hcatalog, PXF >Reporter: Oleksandr Diachenko >Assignee: Oleksandr Diachenko > > As for now user is able to create external HAWQ table on top of Hive table > with complex types(LIST, MAP, STRUCT, UNION) and those types are being > serialized as TEXT. > But if user uses HCatalog integration feature and queries Hive tables having > compex type columns through HAWQ he/she gets error. > The goal is to serialize complex types to text when using HCatalog > integration. > Changes required: > - PXF: > -- add sourceType field to getMetadata endpoint. > - HAWQ: > -- master: > --- update stored procedure pxf_get_item_fields, add sourceType field to > responce. > -- psql: > --- update describe logic for Hive tables to show sourceType column in \d(\d+) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-731) Implement Data Generator
[ https://issues.apache.org/jira/browse/HAWQ-731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279899#comment-15279899 ] ASF GitHub Bot commented on HAWQ-731: - Github user ztao1987 commented on the pull request: https://github.com/apache/incubator-hawq/pull/651#issuecomment-218418128 +1 > Implement Data Generator > - > > Key: HAWQ-731 > URL: https://issues.apache.org/jira/browse/HAWQ-731 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: Lili Ma >Assignee: Jiali Yao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-731) Implement Data Generator
[ https://issues.apache.org/jira/browse/HAWQ-731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279896#comment-15279896 ] ASF GitHub Bot commented on HAWQ-731: - GitHub user ictmalili opened a pull request: https://github.com/apache/incubator-hawq/pull/651 HAWQ-731. Implement Data Generator You can merge this pull request into a Git repository by running: $ git pull https://github.com/ictmalili/incubator-hawq HAWQ-731 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/651.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 #651 commit 17c515b93ce00c88082edd1c159d971313b55e4f Author: Lili MaDate: 2016-05-11T10:09:52Z HAWQ-731. Implement Data Generator > Implement Data Generator > - > > Key: HAWQ-731 > URL: https://issues.apache.org/jira/browse/HAWQ-731 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: Lili Ma >Assignee: Jiali Yao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-731) Implement Data Generator
[ https://issues.apache.org/jira/browse/HAWQ-731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279895#comment-15279895 ] ASF GitHub Bot commented on HAWQ-731: - Github user ictmalili closed the pull request at: https://github.com/apache/incubator-hawq/pull/650 > Implement Data Generator > - > > Key: HAWQ-731 > URL: https://issues.apache.org/jira/browse/HAWQ-731 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: Lili Ma >Assignee: Jiali Yao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-731) Implement Data Generator
Lili Ma created HAWQ-731: Summary: Implement Data Generator Key: HAWQ-731 URL: https://issues.apache.org/jira/browse/HAWQ-731 Project: Apache HAWQ Issue Type: New Feature Components: Tests Reporter: Lili Ma Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhenglin tao updated HAWQ-730: -- Component/s: Core > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test > Components: Core >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279700#comment-15279700 ] ASF GitHub Bot commented on HAWQ-730: - Github user ztao1987 closed the pull request at: https://github.com/apache/incubator-hawq/pull/649 > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279695#comment-15279695 ] ASF GitHub Bot commented on HAWQ-730: - Github user ictmalili commented on the pull request: https://github.com/apache/incubator-hawq/pull/649#issuecomment-218381202 +1 > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhenglin tao reassigned HAWQ-730: - Assignee: zhenglin tao (was: Lei Chang) > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-730) Add return code for PSQL
[ https://issues.apache.org/jira/browse/HAWQ-730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhenglin tao updated HAWQ-730: -- Issue Type: Test (was: Bug) > Add return code for PSQL > > > Key: HAWQ-730 > URL: https://issues.apache.org/jira/browse/HAWQ-730 > Project: Apache HAWQ > Issue Type: Test >Reporter: zhenglin tao >Assignee: Lei Chang > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-728) add wrapper SQLUtility for test usage
[ https://issues.apache.org/jira/browse/HAWQ-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhenglin tao updated HAWQ-728: -- Issue Type: Test (was: Bug) > add wrapper SQLUtility for test usage > - > > Key: HAWQ-728 > URL: https://issues.apache.org/jira/browse/HAWQ-728 > Project: Apache HAWQ > Issue Type: Test > Components: Core >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-730) Add return code for PSQL
zhenglin tao created HAWQ-730: - Summary: Add return code for PSQL Key: HAWQ-730 URL: https://issues.apache.org/jira/browse/HAWQ-730 Project: Apache HAWQ Issue Type: Bug Reporter: zhenglin tao Assignee: Lei Chang -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Reopened] (HAWQ-728) add wrapper SQLUtility for test usage
[ https://issues.apache.org/jira/browse/HAWQ-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] zhenglin tao reopened HAWQ-728: --- > add wrapper SQLUtility for test usage > - > > Key: HAWQ-728 > URL: https://issues.apache.org/jira/browse/HAWQ-728 > Project: Apache HAWQ > Issue Type: Bug > Components: Core >Reporter: zhenglin tao >Assignee: zhenglin tao > -- This message was sent by Atlassian JIRA (v6.3.4#6332)