RE: Not able to create table in hive

2012-02-02 Thread Manish . Bhoge
Thanks Mark, I do have an access on metastore as I am login as admin. However when I query through Hue web interface it is working for me (using User: Guest). Here is how my hive-site.xml looks like. Is there any property that I need to extend here. javax.jdo.option.ConnectionURL jdbc

[jira] [Updated] (HIVE-2686) Test ppr_pushdown.q is failing on trunk

2012-02-02 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2686: -- Attachment: HIVE-2686.D1215.3.patch navis updated the revision "HIVE-2686 [jira] Test ppr_pushdown.q is

[jira] [Updated] (HIVE-2756) Views should be added to the inputs of queries.

2012-02-02 Thread Namit Jain (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2756: - Resolution: Fixed Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committe

Re: Table not creating in hive

2012-02-02 Thread Bhavesh Shah
Hello Bejoy & Alexis, Thanks for your reply. I am using mysql as a database (and not derby) Previuosly I am using --split by 1 and is working fine, but when I installed MySQL and change the database then I got the error for --split-by option and thats why I use -m 1. But again due to that it is sho

[jira] [Updated] (HIVE-2542) DROP DATABASE CASCADE does not drop non-native tables.

2012-02-02 Thread Vandana Ayyalasomayajula (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vandana Ayyalasomayajula updated HIVE-2542: --- Attachment: Hive-2542.03.patch > DROP DATABASE CASCADE does not drop non-n

[jira] [Commented] (HIVE-2372) java.io.IOException: error=7, Argument list too long

2012-02-02 Thread Siying Dong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2372?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199411#comment-13199411 ] Siying Dong commented on HIVE-2372: --- Is 2048 per value too long? > java.

[jira] [Commented] (HIVE-2762) Alter Table Partition Concatenate Fails On Certain Characters

2012-02-02 Thread Hudson (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199375#comment-13199375 ] Hudson commented on HIVE-2762: -- Integrated in Hive-trunk-h0.21 #1240 (See [https://builds.apa

Hive-trunk-h0.21 - Build # 1240 - Still Failing

2012-02-02 Thread Apache Jenkins Server
Changes for Build #1198 [namit] HIVE-2504 Warehouse table subdirectories should inherit the group permissions of the warehouse parent directory (Chinna Rao Lalam via namit) [namit] HIVE-2695 Add PRINTF() Udf (Zhenxiao Luo via namit) Changes for Build #1199 Changes for Build #1200 Changes for

[jira] [Updated] (HIVE-1648) Automatically gathering statistics when reading a table/partition

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1648: - Component/s: Statistics Summary: Automatically gathering statistics when reading a table/p

[jira] [Updated] (HIVE-2093) create/drop database should populate inputs/outputs and check concurrency and user permission

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2093: - Component/s: Locking Authorization > create/drop database should populate inp

[jira] [Updated] (HIVE-2743) Enable SASL mode for HiveServer

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2743: - Component/s: Authentication > Enable SASL mode for HiveServer > --

[jira] [Updated] (HIVE-842) Authentication Infrastructure for Hive

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-842: Component/s: Authentication > Authentication Infrastructure for Hive > --

[jira] [Updated] (HIVE-1696) Add delegation token support to metastore

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1696: - Component/s: Authentication > Add delegation token support to metastore >

[jira] [Updated] (HIVE-1935) set hive.security.authorization.createtable.owner.grants to null by default

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1935: - Component/s: Authorization > set hive.security.authorization.createtable.owner.grants to null

[jira] [Updated] (HIVE-2241) Thrift MetaStore interface bypasses authorization checks

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2241: - Component/s: Authorization > Thrift MetaStore interface bypasses authorization checks > --

[jira] [Updated] (HIVE-78) Authorization infrastructure for Hive

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-78?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-78: --- Component/s: Authorization > Authorization infrastructure for Hive > ---

[jira] [Updated] (HIVE-1930) new configuration to disable all authorization related metadata changes

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1930: - Component/s: Authorization > new configuration to disable all authorization related metadata c

[jira] [Updated] (HIVE-2554) Hive authorization with remote metastore does not work

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2554: - Component/s: Authorization > Hive authorization with remote metastore does not work >

[jira] [Updated] (HIVE-2472) Metastore statistics are not being updated for CTAS queries.

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2472: - Component/s: Statistics > Metastore statistics are not being updated for CTAS queries. > -

[jira] [Updated] (HIVE-33) [Hive]: Add ability to compute statistics on hive tables

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-33?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-33: --- Component/s: Statistics > [Hive]: Add ability to compute statistics on hive tables > ---

[jira] [Updated] (HIVE-1938) Cost Based Query optimization for Joins in Hive

2012-02-02 Thread Carl Steinbach (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1938: - Component/s: Statistics > Cost Based Query optimization for Joins in Hive > --

[jira] [Updated] (HIVE-1634) Allow access to Primitive types stored in binary format in HBase

2012-02-02 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-1634: -- Attachment: HIVE-1634.D1581.1.patch ashutoshc requested code review of "HIVE-1634 [jira] Allow access to

[jira] [Commented] (HIVE-2756) Views should be added to the inputs of queries.

2012-02-02 Thread Phabricator (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199251#comment-13199251 ] Phabricator commented on HIVE-2756: --- njain has accepted the revision "HIVE-2756 [jira] Vi

[jira] [Updated] (HIVE-2756) Views should be added to the inputs of queries.

2012-02-02 Thread Namit Jain (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2756: - Status: Patch Available (was: Open) > Views should be added to the inputs of queries. > -

[jira] [Commented] (HIVE-2776) Setting test.silent=false has not effect

2012-02-02 Thread Carl Steinbach (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199175#comment-13199175 ] Carl Steinbach commented on HIVE-2776: -- QTestUtil and the various CliDriver templates

[jira] [Created] (HIVE-2776) Setting test.silent=false has not effect

2012-02-02 Thread Carl Steinbach (Created) (JIRA)
Setting test.silent=false has not effect Key: HIVE-2776 URL: https://issues.apache.org/jira/browse/HIVE-2776 Project: Hive Issue Type: Bug Components: Testing Infrastructure Repo

[jira] [Commented] (HIVE-2747) UNION ALL with subquery which selects NULL and performs group by fails

2012-02-02 Thread Namit Jain (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199166#comment-13199166 ] Namit Jain commented on HIVE-2747: -- Even a error message for now is fine. The implicit typ

[jira] [Updated] (HIVE-2747) UNION ALL with subquery which selects NULL and performs group by fails

2012-02-02 Thread Namit Jain (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2747: - Assignee: (was: Kevin Wilfong) > UNION ALL with subquery which selects NULL and performs group by

[jira] [Commented] (HIVE-2747) UNION ALL with subquery which selects NULL and performs group by fails

2012-02-02 Thread Kevin Wilfong (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199153#comment-13199153 ] Kevin Wilfong commented on HIVE-2747: - Namit, that looks like the issue in the JIRA htt

Hive-0.8.1-SNAPSHOT-h0.21 - Build # 183 - Fixed

2012-02-02 Thread Apache Jenkins Server
Changes for Build #181 Changes for Build #182 Changes for Build #183 All tests passed The Apache Jenkins build system has built Hive-0.8.1-SNAPSHOT-h0.21 (build #183) Status: Fixed Check console output at https://builds.apache.org/job/Hive-0.8.1-SNAPSHOT-h0.21/183/ to view the results.

Not able to create table in hive

2012-02-02 Thread Manish . Bhoge
Hi, I am trying to create a table in Hive using below DDL: CREATE TABLE pokes (foo INT, bar STRING); I am getting below error, I have logged in as admin user : FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated obje

[jira] [Commented] (HIVE-2747) UNION ALL with subquery which selects NULL and performs group by fails

2012-02-02 Thread Namit Jain (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199099#comment-13199099 ] Namit Jain commented on HIVE-2747: -- create table tmp_tx1 (key string, value string); inse

[jira] [Updated] (HIVE-2762) Alter Table Partition Concatenate Fails On Certain Characters

2012-02-02 Thread Ashutosh Chauhan (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-2762: --- Component/s: Metastore Fix Version/s: 0.9.0 > Alter Table Partition Concatenate Fail

[jira] [Updated] (HIVE-2762) Alter Table Partition Concatenate Fails On Certain Characters

2012-02-02 Thread Namit Jain (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2762: - Resolution: Fixed Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committe

[jira] [Updated] (HIVE-2756) Views should be added to the inputs of queries.

2012-02-02 Thread Phabricator (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2756: -- Attachment: HIVE-2756.D1575.1.patch kevinwilfong requested code review of "HIVE-2756 [jira] Views should

[jira] [Commented] (HIVE-2761) Remove lib/javaewah-0.3.jar

2012-02-02 Thread Daniel Lemire (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199043#comment-13199043 ] Daniel Lemire commented on HIVE-2761: - That is correct. We upgraded the version of Java

[jira] [Updated] (HIVE-2756) Views should be added to the inputs of queries.

2012-02-02 Thread Kevin Wilfong (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-2756: Description: Views, in addition to the underlying tables, should be included in the inputs of a com

Hive-trunk-h0.21 - Build # 1239 - Still Failing

2012-02-02 Thread Apache Jenkins Server
Changes for Build #1195 [hashutosh] HIVE-2589: Newly created partition should inherit properties from table (Ashutosh Chauhan) [hashutosh] HIVE-2682: Clean-up logs (Rajat Goel via Ashutosh Chauhan) Changes for Build #1196 [amareshwari] HIVE-2629. Make a single Hive binary work with both 0.20.x

Re: Table not creating in hive

2012-02-02 Thread Alexis De La Cruz Toledo
This is because you need the metastore. If you aren't installed in a databases, it installed with derby in the directory when you access to hive, remember where was it. There you should find the directory name _metastore and in this directory access to hive. Regards. El 2 de febrero de 2012 05:46

Table not creating in hive

2012-02-02 Thread Bhavesh Shah
Hello all, After successfully importing the tables in hive I am not able to see the table in Hive. When I imported the table I saw the dir on HDFS (under /user/hive/warehouse/) but when I execute command in Hive "SHOW TABLES" the table is not in the list. I find a lot about it but not getting any