[jira] [Resolved] (HAWQ-1091) HAWQ InputFormat Bugs

2016-10-09 Thread hongwu (JIRA)

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

hongwu resolved HAWQ-1091.
--
   Resolution: Fixed
Fix Version/s: 2.0.1.0-incubating

> HAWQ InputFormat Bugs
> -
>
> Key: HAWQ-1091
> URL: https://issues.apache.org/jira/browse/HAWQ-1091
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Command Line Tools
>Reporter: hongwu
>Assignee: hongwu
> Fix For: 2.0.1.0-incubating
>
>
> In "TPCHLocalTester.java" and "HAWQInputFormatPerformanceTest_TPCH.java", it 
> uses "WHERE content>=0" filter which is old condition in old version of HAWQ.
> dbgen binary is not included in hawq repo which is needed for 
> generate_load_tpch.pl script to generate data used for running mapreduce test 
> cases. We should disable these cases.
> A bug when size in extracted yaml file is zero.



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


[GitHub] incubator-hawq pull request #954: HAWQ-1091. Fix HAWQ InputFormat Bugs.

2016-10-09 Thread xunzhang
Github user xunzhang closed the pull request at:

https://github.com/apache/incubator-hawq/pull/954


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq issue #954: HAWQ-1091. Fix HAWQ InputFormat Bugs.

2016-10-09 Thread xunzhang
Github user xunzhang commented on the issue:

https://github.com/apache/incubator-hawq/pull/954
  
Merged into master.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Resolved] (HAWQ-1093) Bump Orca version and enable Orca related exception propagation

2016-10-09 Thread Ming LI (JIRA)

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

Ming LI resolved HAWQ-1093.
---
   Resolution: Fixed
Fix Version/s: backlog

> Bump Orca version and enable Orca related exception propagation
> ---
>
> Key: HAWQ-1093
> URL: https://issues.apache.org/jira/browse/HAWQ-1093
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Optimizer
>Reporter: Haisheng Yuan
>Assignee: Haisheng Yuan
> Fix For: backlog
>
>




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


[GitHub] incubator-hawq pull request #896: [#126526845] Port recent changes from gpdb...

2016-10-09 Thread asfgit
Github user asfgit closed the pull request at:

https://github.com/apache/incubator-hawq/pull/896


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq issue #950: HAWQ-991. Refator HAWQ Register code to make sure...

2016-10-09 Thread linwen
Github user linwen commented on the issue:

https://github.com/apache/incubator-hawq/pull/950
  
LGTM 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Assigned] (HAWQ-1093) Bump Orca version and enable Orca related exception propagation

2016-10-09 Thread Haisheng Yuan (JIRA)

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

Haisheng Yuan reassigned HAWQ-1093:
---

Assignee: Haisheng Yuan  (was: Lei Chang)

> Bump Orca version and enable Orca related exception propagation
> ---
>
> Key: HAWQ-1093
> URL: https://issues.apache.org/jira/browse/HAWQ-1093
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Optimizer
>Reporter: Haisheng Yuan
>Assignee: Haisheng Yuan
>




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


[GitHub] incubator-hawq issue #896: [#126526845] Port recent changes from gpdb for ha...

2016-10-09 Thread hsyuan
Github user hsyuan commented on the issue:

https://github.com/apache/incubator-hawq/pull/896
  
@liming01 Done. 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Created] (HAWQ-1093) Bump Orca version and enable Orca related exception propagation

2016-10-09 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created HAWQ-1093:
---

 Summary: Bump Orca version and enable Orca related exception 
propagation
 Key: HAWQ-1093
 URL: https://issues.apache.org/jira/browse/HAWQ-1093
 Project: Apache HAWQ
  Issue Type: Improvement
  Components: Optimizer
Reporter: Haisheng Yuan
Assignee: Lei Chang






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


[GitHub] incubator-hawq issue #950: HAWQ-991. Refator HAWQ Register code for partitio...

2016-10-09 Thread ictmalili
Github user ictmalili commented on the issue:

https://github.com/apache/incubator-hawq/pull/950
  
@wcl14 Could you change the description for this Pull Request, since it 
only covers code refactor part. The partition table support can be processed by 
another PR. Thanks


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq pull request #954: [WIP] HAWQ-1091. Fix HAWQ InputFormat Bugs...

2016-10-09 Thread ictmalili
Github user ictmalili commented on a diff in the pull request:

https://github.com/apache/incubator-hawq/pull/954#discussion_r82523067
  
--- Diff: 
contrib/hawq-hadoop/hawq-mapreduce-common/src/main/java/com/pivotal/hawq/mapreduce/metadata/MetadataYAMLAccessor.java
 ---
@@ -198,6 +201,9 @@ private HAWQParquetTableMetadata 
extractParquetMetadata(HAWQDatabaseMetadata dbM
Map file = (Map) files.get(i);
final String filePath = file.get("path").toString();
final long fileLen = 
Long.parseLong(file.get("size").toString());
+   if (fileLen == 0) {
+ throw new IllegalStateException("Could not new 
HAWQParquetFileStatus with a empty file.");
+   }
--- End diff --

Could we change the error message to a more meaningful description.  For 
example, "Empty file $filePath, can not be processed by HAWQParquetInputFormat"


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq pull request #954: HAWQ-1091. Fix HAWQ InputFormat Bugs.

2016-10-09 Thread xunzhang
GitHub user xunzhang opened a pull request:

https://github.com/apache/incubator-hawq/pull/954

HAWQ-1091. Fix HAWQ InputFormat Bugs.



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

$ git pull https://github.com/xunzhang/incubator-hawq HAWQ-1091

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

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


commit 5b03771e8d7ce647312a09caa780fab505c89b22
Author: xunzhang 
Date:   2016-10-09T12:35:31Z

HAWQ-1091. Fix HAWQ InputFormat Bugs.




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq issue #954: HAWQ-1091. Fix HAWQ InputFormat Bugs.

2016-10-09 Thread xunzhang
Github user xunzhang commented on the issue:

https://github.com/apache/incubator-hawq/pull/954
  
cc @ictmalili @wcl14 


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Commented] (HAWQ-1092) lc_collate and lc_ctype do not work after setting through hawq init

2016-10-09 Thread Paul Guo (JIRA)

[ 
https://issues.apache.org/jira/browse/HAWQ-1092?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15559751#comment-15559751
 ] 

Paul Guo commented on HAWQ-1092:


With a preliminary fix,
https://github.com/apache/incubator-hawq/pull/953

Now the results look like below:

# psql -d postgres -c "SELECT name, setting from pg_settings where name like 
'lc%'"
name |  setting
-+
 lc_collate  | ja_JP.utf8
 lc_ctype| ja_JP.utf8
 lc_messages | ja_JP.utf8
 lc_monetary | ja_JP.utf8
 lc_numeric  | ja_JP.utf8
 lc_time | ja_JP.utf8
(6 rows)

# psql postgres -f sort2.sql
... 
 id | name
+--
  4 | DEF
  3 | abd
  5 | ghi
  1 | ウ
  2 | チ
(5 rows)

> lc_collate and lc_ctype do not work after setting through hawq init
> ---
>
> Key: HAWQ-1092
> URL: https://issues.apache.org/jira/browse/HAWQ-1092
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Catalog, Command Line Tools
>Reporter: Paul Guo
>Assignee: Lei Chang
>
> Users reports this issue to us, to reproduce:
> {noformat}
> # hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
> ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
> ja_JP.utf8 --lc-time ja_JP.utf8
> #psql -d postgres -c "SELECT name, setting from pg_settings where name like 
> 'lc%'"
> name |  setting
> -+
>  lc_collate  | C
>  lc_ctype| C
>  lc_messages | ja_JP.utf8
>  lc_monetary | ja_JP.utf8
>  lc_numeric  | ja_JP.utf8
>  lc_time | ja_JP.utf8
> (6 rows)
> {noformat}
> Besides, the sorting result is also not correct in some cases.
> {noformat}
> # cat sort2.sql
> DROP TABLE IF EXISTS t;
> CREATE TABLE t (id INT, name TEXT);
> INSERT INTO t VALUES (1, 'ウ');
> INSERT INTO t VALUES (2, 'チ');
> INSERT INTO t VALUES (3, 'abd');
> INSERT INTO t VALUES (4, 'DEF');
> INSERT INTO t VALUES (5, 'ghi');
> SELECT * FROM t ORDER BY name;
> #  psql postgres -f sort2.sql
> 
>  id | name
> +--
>   1 | ウ
>   2 | チ
>   3 | abd
>   4 | DEF
>   5 | ghi
> (5 rows)
> {noformat}



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


[jira] [Updated] (HAWQ-1092) lc_collate and lc_ctype do not work after setting through hawq init

2016-10-09 Thread Ruilong Huo (JIRA)

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

Ruilong Huo updated HAWQ-1092:
--
Description: 
Users reports this issue to us, to reproduce:
{noformat}
# hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
ja_JP.utf8 --lc-time ja_JP.utf8

#psql -d postgres -c "SELECT name, setting from pg_settings where name like 
'lc%'"
name |  setting
-+
 lc_collate  | C
 lc_ctype| C
 lc_messages | ja_JP.utf8
 lc_monetary | ja_JP.utf8
 lc_numeric  | ja_JP.utf8
 lc_time | ja_JP.utf8
(6 rows)
{noformat}
Besides, the sorting result is also not correct in some cases.
{noformat}
# cat sort2.sql
DROP TABLE IF EXISTS t;
CREATE TABLE t (id INT, name TEXT);

INSERT INTO t VALUES (1, 'ウ');
INSERT INTO t VALUES (2, 'チ');
INSERT INTO t VALUES (3, 'abd');
INSERT INTO t VALUES (4, 'DEF');
INSERT INTO t VALUES (5, 'ghi');

SELECT * FROM t ORDER BY name;

#  psql postgres -f sort2.sql

 id | name
+--
  1 | ウ
  2 | チ
  3 | abd
  4 | DEF
  5 | ghi
(5 rows)
{noformat}


  was:
Users reports this issue to us, to reproduce:

# hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
ja_JP.utf8 --lc-time ja_JP.utf8

#psql -d postgres -c "SELECT name, setting from pg_settings where name like 
'lc%'"
name |  setting
-+
 lc_collate  | C
 lc_ctype| C
 lc_messages | ja_JP.utf8
 lc_monetary | ja_JP.utf8
 lc_numeric  | ja_JP.utf8
 lc_time | ja_JP.utf8
(6 rows)

Besides, the sorting result is also not correct in some cases.

# cat sort2.sql
DROP TABLE IF EXISTS t;
CREATE TABLE t (id INT, name TEXT);

INSERT INTO t VALUES (1, 'ウ');
INSERT INTO t VALUES (2, 'チ');
INSERT INTO t VALUES (3, 'abd');
INSERT INTO t VALUES (4, 'DEF');
INSERT INTO t VALUES (5, 'ghi');

SELECT * FROM t ORDER BY name;

#  psql postgres -f sort2.sql

 id | name
+--
  1 | ウ
  2 | チ
  3 | abd
  4 | DEF
  5 | ghi
(5 rows)




> lc_collate and lc_ctype do not work after setting through hawq init
> ---
>
> Key: HAWQ-1092
> URL: https://issues.apache.org/jira/browse/HAWQ-1092
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Catalog, Command Line Tools
>Reporter: Paul Guo
>Assignee: Lei Chang
>
> Users reports this issue to us, to reproduce:
> {noformat}
> # hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
> ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
> ja_JP.utf8 --lc-time ja_JP.utf8
> #psql -d postgres -c "SELECT name, setting from pg_settings where name like 
> 'lc%'"
> name |  setting
> -+
>  lc_collate  | C
>  lc_ctype| C
>  lc_messages | ja_JP.utf8
>  lc_monetary | ja_JP.utf8
>  lc_numeric  | ja_JP.utf8
>  lc_time | ja_JP.utf8
> (6 rows)
> {noformat}
> Besides, the sorting result is also not correct in some cases.
> {noformat}
> # cat sort2.sql
> DROP TABLE IF EXISTS t;
> CREATE TABLE t (id INT, name TEXT);
> INSERT INTO t VALUES (1, 'ウ');
> INSERT INTO t VALUES (2, 'チ');
> INSERT INTO t VALUES (3, 'abd');
> INSERT INTO t VALUES (4, 'DEF');
> INSERT INTO t VALUES (5, 'ghi');
> SELECT * FROM t ORDER BY name;
> #  psql postgres -f sort2.sql
> 
>  id | name
> +--
>   1 | ウ
>   2 | チ
>   3 | abd
>   4 | DEF
>   5 | ghi
> (5 rows)
> {noformat}



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


[jira] [Updated] (HAWQ-1092) lc_collate and lc_ctype do not work after setting through hawq init

2016-10-09 Thread Ruilong Huo (JIRA)

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

Ruilong Huo updated HAWQ-1092:
--
Component/s: Command Line Tools
 Catalog

> lc_collate and lc_ctype do not work after setting through hawq init
> ---
>
> Key: HAWQ-1092
> URL: https://issues.apache.org/jira/browse/HAWQ-1092
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Catalog, Command Line Tools
>Reporter: Paul Guo
>Assignee: Lei Chang
>
> Users reports this issue to us, to reproduce:
> # hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
> ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
> ja_JP.utf8 --lc-time ja_JP.utf8
> #psql -d postgres -c "SELECT name, setting from pg_settings where name like 
> 'lc%'"
> name |  setting
> -+
>  lc_collate  | C
>  lc_ctype| C
>  lc_messages | ja_JP.utf8
>  lc_monetary | ja_JP.utf8
>  lc_numeric  | ja_JP.utf8
>  lc_time | ja_JP.utf8
> (6 rows)
> Besides, the sorting result is also not correct in some cases.
> # cat sort2.sql
> DROP TABLE IF EXISTS t;
> CREATE TABLE t (id INT, name TEXT);
> INSERT INTO t VALUES (1, 'ウ');
> INSERT INTO t VALUES (2, 'チ');
> INSERT INTO t VALUES (3, 'abd');
> INSERT INTO t VALUES (4, 'DEF');
> INSERT INTO t VALUES (5, 'ghi');
> SELECT * FROM t ORDER BY name;
> #  psql postgres -f sort2.sql
> 
>  id | name
> +--
>   1 | ウ
>   2 | チ
>   3 | abd
>   4 | DEF
>   5 | ghi
> (5 rows)



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


[GitHub] incubator-hawq pull request #953: HAWQ-1092. lc_collate and lc_ctype do not ...

2016-10-09 Thread paul-guo-
GitHub user paul-guo- opened a pull request:

https://github.com/apache/incubator-hawq/pull/953

HAWQ-1092. lc_collate and lc_ctype do not work after setting through …

…hawq init

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

$ git pull https://github.com/paul-guo-/incubator-hawq build

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

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


commit c36e213fe6c7ab3bd3744bf2f18293fc5732e5f5
Author: Paul Guo 
Date:   2016-10-09T09:47:32Z

HAWQ-1092. lc_collate and lc_ctype do not work after setting through hawq 
init




---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Updated] (HAWQ-1092) lc_collate and lc_ctype do not work after setting through hawq init

2016-10-09 Thread Paul Guo (JIRA)

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

Paul Guo updated HAWQ-1092:
---
Summary: lc_collate and lc_ctype do not work after setting through hawq 
init  (was: Setting lc_collate and lc_ctype through hawq init does not work.)

> lc_collate and lc_ctype do not work after setting through hawq init
> ---
>
> Key: HAWQ-1092
> URL: https://issues.apache.org/jira/browse/HAWQ-1092
> Project: Apache HAWQ
>  Issue Type: Bug
>Reporter: Paul Guo
>Assignee: Lei Chang
>
> Users reports this issue to us, to reproduce:
> # hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
> ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
> ja_JP.utf8 --lc-time ja_JP.utf8
> #psql -d postgres -c "SELECT name, setting from pg_settings where name like 
> 'lc%'"
> name |  setting
> -+
>  lc_collate  | C
>  lc_ctype| C
>  lc_messages | ja_JP.utf8
>  lc_monetary | ja_JP.utf8
>  lc_numeric  | ja_JP.utf8
>  lc_time | ja_JP.utf8
> (6 rows)
> Besides, the sorting result is also not correct in some cases.
> # cat sort2.sql
> DROP TABLE IF EXISTS t;
> CREATE TABLE t (id INT, name TEXT);
> INSERT INTO t VALUES (1, 'ウ');
> INSERT INTO t VALUES (2, 'チ');
> INSERT INTO t VALUES (3, 'abd');
> INSERT INTO t VALUES (4, 'DEF');
> INSERT INTO t VALUES (5, 'ghi');
> SELECT * FROM t ORDER BY name;
> #  psql postgres -f sort2.sql
> 
>  id | name
> +--
>   1 | ウ
>   2 | チ
>   3 | abd
>   4 | DEF
>   5 | ghi
> (5 rows)



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


[jira] [Created] (HAWQ-1092) Setting lc_collate and lc_ctype through hawq init does not work.

2016-10-09 Thread Paul Guo (JIRA)
Paul Guo created HAWQ-1092:
--

 Summary: Setting lc_collate and lc_ctype through hawq init does 
not work.
 Key: HAWQ-1092
 URL: https://issues.apache.org/jira/browse/HAWQ-1092
 Project: Apache HAWQ
  Issue Type: Bug
Reporter: Paul Guo
Assignee: Lei Chang


Users reports this issue to us, to reproduce:

# hawq init cluster -a --locale ja_JP.utf8 --lc-collate ja_JP.utf8 --lc-ctype 
ja_JP.utf8 --lc-messages ja_JP.utf8 --lc-monetary ja_JP.utf8 --lc-numeric 
ja_JP.utf8 --lc-time ja_JP.utf8

#psql -d postgres -c "SELECT name, setting from pg_settings where name like 
'lc%'"
name |  setting
-+
 lc_collate  | C
 lc_ctype| C
 lc_messages | ja_JP.utf8
 lc_monetary | ja_JP.utf8
 lc_numeric  | ja_JP.utf8
 lc_time | ja_JP.utf8
(6 rows)

Besides, the sorting result is also not correct in some cases.

# cat sort2.sql
DROP TABLE IF EXISTS t;
CREATE TABLE t (id INT, name TEXT);

INSERT INTO t VALUES (1, 'ウ');
INSERT INTO t VALUES (2, 'チ');
INSERT INTO t VALUES (3, 'abd');
INSERT INTO t VALUES (4, 'DEF');
INSERT INTO t VALUES (5, 'ghi');

SELECT * FROM t ORDER BY name;

#  psql postgres -f sort2.sql

 id | name
+--
  1 | ウ
  2 | チ
  3 | abd
  4 | DEF
  5 | ghi
(5 rows)





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


[jira] [Reopened] (HAWQ-1034) add --repair option for hawq register

2016-10-09 Thread Lili Ma (JIRA)

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

Lili Ma reopened HAWQ-1034:
---

> add --repair option for hawq register
> -
>
> Key: HAWQ-1034
> URL: https://issues.apache.org/jira/browse/HAWQ-1034
> Project: Apache HAWQ
>  Issue Type: Sub-task
>  Components: Command Line Tools
>Affects Versions: 2.0.1.0-incubating
>Reporter: Lili Ma
>Assignee: hongwu
> Fix For: 2.0.1.0-incubating
>
>
> add --repair option for hawq register
> Will change both file folder and catalog table pg_aoseg.pg_paqseg_$relid to 
> the state which .yml file configures. Note may some new generated files since 
> the checkpoint may be deleted here. Also note the all the files in .yml file 
> should all under the table folder on HDFS. Limitation: Do not support cases 
> for hash table redistribution, table truncate and table drop. This is for 
> scenario rollback of table: Do checkpoints somewhere, and need to rollback to 
> previous checkpoint. 



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


[jira] [Closed] (HAWQ-1051) failing in reverse DNS lookup causes resource manager core dump

2016-10-09 Thread Xiang Sheng (JIRA)

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

Xiang Sheng closed HAWQ-1051.
-

> failing in reverse DNS lookup causes resource manager core dump
> ---
>
> Key: HAWQ-1051
> URL: https://issues.apache.org/jira/browse/HAWQ-1051
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Resource Manager
>Reporter: Yi Jin
>Assignee: Yi Jin
> Fix For: backlog
>
>
> This is caused due to wrongly expecting gethostbyaddr() return values. 



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


[jira] [Resolved] (HAWQ-1051) failing in reverse DNS lookup causes resource manager core dump

2016-10-09 Thread Xiang Sheng (JIRA)

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

Xiang Sheng resolved HAWQ-1051.
---
Resolution: Fixed

> failing in reverse DNS lookup causes resource manager core dump
> ---
>
> Key: HAWQ-1051
> URL: https://issues.apache.org/jira/browse/HAWQ-1051
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Resource Manager
>Reporter: Yi Jin
>Assignee: Yi Jin
> Fix For: backlog
>
>
> This is caused due to wrongly expecting gethostbyaddr() return values. 



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


[GitHub] incubator-hawq issue #928: HAWQ-1051. Failing in reverse DNS lookup causes r...

2016-10-09 Thread stanlyxiang
Github user stanlyxiang commented on the issue:

https://github.com/apache/incubator-hawq/pull/928
  
Merged.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[GitHub] incubator-hawq pull request #928: HAWQ-1051. Failing in reverse DNS lookup c...

2016-10-09 Thread stanlyxiang
Github user stanlyxiang closed the pull request at:

https://github.com/apache/incubator-hawq/pull/928


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---


[jira] [Assigned] (HAWQ-1091) HAWQ InputFormat Bugs

2016-10-09 Thread hongwu (JIRA)

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

hongwu reassigned HAWQ-1091:


Assignee: hongwu  (was: Lei Chang)

> HAWQ InputFormat Bugs
> -
>
> Key: HAWQ-1091
> URL: https://issues.apache.org/jira/browse/HAWQ-1091
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Command Line Tools
>Reporter: hongwu
>Assignee: hongwu
>
> In "TPCHLocalTester.java" and "HAWQInputFormatPerformanceTest_TPCH.java", it 
> uses "WHERE content>=0" filter which is old condition in old version of HAWQ.
> dbgen binary is not included in hawq repo which is needed for 
> generate_load_tpch.pl script to generate data used for running mapreduce test 
> cases. We should disable these cases.
> A bug when size in extracted yaml file is zero.



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


[jira] [Created] (HAWQ-1091) HAWQ InputFormat Bugs

2016-10-09 Thread hongwu (JIRA)
hongwu created HAWQ-1091:


 Summary: HAWQ InputFormat Bugs
 Key: HAWQ-1091
 URL: https://issues.apache.org/jira/browse/HAWQ-1091
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Command Line Tools
Reporter: hongwu
Assignee: Lei Chang


In "TPCHLocalTester.java" and "HAWQInputFormatPerformanceTest_TPCH.java", it 
uses "WHERE content>=0" filter which is old condition in old version of HAWQ.

dbgen binary is not included in hawq repo which is needed for 
generate_load_tpch.pl script to generate data used for running mapreduce test 
cases. We should disable these cases.

A bug when size in extracted yaml file is zero.



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