[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-08 Thread Xuefu Zhang (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14125692#comment-14125692
 ] 

Xuefu Zhang commented on HIVE-1363:
---

Thanks, [~leftylev]. It seems to me that is a just a bug fix.

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 0.5.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.1.patch, HIVE-1363.2.patch, HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-07 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14124819#comment-14124819
 ] 

Hive QA commented on HIVE-1363:
---



{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667057/HIVE-1363.2.patch

{color:green}SUCCESS:{color} +1 6184 tests passed

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/678/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/678/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-678/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12667057

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.5.0, 0.14.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.1.patch, HIVE-1363.2.patch, HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-07 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14125229#comment-14125229
 ] 

Lefty Leverenz commented on HIVE-1363:
--

_If_ this needs to be documented in the wiki, here's where it goes (but maybe 
it's just a bug fix that doesn't need user documentation):

* [Language Manual -- DDL -- Show Table/Partition Extended | 
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowTable/PartitionExtended]

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
  Components: Query Processor
Affects Versions: 0.5.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.1.patch, HIVE-1363.2.patch, HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-06 Thread Pradeep Kamath (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14124348#comment-14124348
 ] 

Pradeep Kamath commented on HIVE-1363:
--

This email account is inactive. Please contact another person at the company or 
pe...@fb.com.


 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.5.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang

 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-06 Thread Xuefu Zhang (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14124508#comment-14124508
 ] 

Xuefu Zhang commented on HIVE-1363:
---

Thanks for working on this, [~ctang.cloudera]. Patch looks good to me. Minor 
comment on RB.

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.5.0, 0.14.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-06 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14124687#comment-14124687
 ] 

Hive QA commented on HIVE-1363:
---



{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12667028/HIVE-1363.1.patch

{color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 6184 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_describe_table_json
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/672/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/672/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-672/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 1 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12667028

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.5.0, 0.14.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.1.patch, HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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

[jira] [Commented] (HIVE-1363) 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes

2014-09-06 Thread Xuefu Zhang (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14124760#comment-14124760
 ] 

Xuefu Zhang commented on HIVE-1363:
---

+1, pending on the new test result.

 'SHOW TABLE EXTENDED LIKE' command does not strip single/double quotes
 --

 Key: HIVE-1363
 URL: https://issues.apache.org/jira/browse/HIVE-1363
 Project: Hive
  Issue Type: Bug
Affects Versions: 0.5.0, 0.14.0
Reporter: Carl Steinbach
Assignee: Chaoyu Tang
 Fix For: 0.14.0

 Attachments: HIVE-1363.1.patch, HIVE-1363.2.patch, HIVE-1363.patch


 {code}
 hive SHOW TABLE EXTENDED LIKE pokes;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 hive SHOW TABLE EXTENDED LIKE p*;
 FAILED: Error in metadata: MetaException(message:Got exception: 
 javax.jdo.JDOUserException ')' expected at character 54 in database.name == 
 dbName  ( tableName.matches((?i)p.*)))
 FAILED: Execution Error, return code 1 from 
 org.apache.hadoop.hive.ql.exec.DDLTask
 hive SHOW TABLE EXTENDED LIKE 'p*';
 OK
 hive SHOW TABLE EXTENDED LIKE `p*`;
 OK
 tableName:pokes
 owner:carl
 location:hdfs://localhost/user/hive/warehouse/pokes
 inputformat:org.apache.hadoop.mapred.TextInputFormat
 outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 columns:struct columns { i32 num}
 partitioned:false
 partitionColumns:
 totalNumberFiles:0
 totalFileSize:0
 maxFileSize:0
 minFileSize:0
 lastAccessTime:0
 lastUpdateTime:1274517075221
 {code}



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