[jira] [Created] (HIVE-4102) Can't drop table with Postgresql metastore

["sekine coulibaly (JIRA)" <ji...@apache.org>]

sekine coulibaly created HIVE-4102:
--------------------------------------

             Summary: Can't drop table with Postgresql metastore
                 Key: HIVE-4102
                 URL: https://issues.apache.org/jira/browse/HIVE-4102
             Project: Hive
          Issue Type: Bug
          Components: Database/Schema
    Affects Versions: 0.10.0
         Environment: Centos 6.3
CDH 4.2.0
            Reporter: sekine coulibaly


Setup a fresh hive install, create a table pointing to an HDFS file.
Then, when trying to drop that table, the CLI hangs for a while and then displays :

hive> drop table log;
FAILED: Error in metadata: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Trying another time :

hive> drop table log;
FAILED: SemanticException [Error 10001]: Table not found log

getting tables list :

hive> show tables;
FAILED: Error in metadata: MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> 

For this last query, the Postgresql logs showthe following :
LOG:  connection received: host=127.0.0.1 port=49717
LOG:  connection authorized: user=hiveuser database=metastore
LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
LOG:  execute S_1: BEGIN
LOG:  execute <unnamed>: SELECT 'org.apache.hadoop.hive.metastore.model.MDatabase' AS NUCLEUS_TYPE,"THIS"."DESC","THIS"."DB_LOCATION_URI","THIS"."NAME","THIS"."DB_ID" FROM "DBS" "THIS" WHERE "THIS"."NAME" = $1
DETAIL:  parameters: $1 = 'default'
LOG:  execute <unnamed>: SELECT "A0"."PARAM_KEY","A0"."PARAM_VALUE" FROM "DATABASE_PARAMS" "A0" WHERE "A0"."DB_ID" = $1 AND "A0"."PARAM_KEY" IS NOT NULL
DETAIL:  parameters: $1 = '1'
LOG:  execute S_2: COMMIT
LOG:  execute <unnamed>: SHOW TRANSACTION ISOLATION LEVEL
LOG:  execute S_1: BEGIN
WARNING:  nonstandard use of \\ in a string literal at character 234
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.

(standard_conforming_strings = off).

Would this help ? http://mapredit.blogspot.fr/2012/12/hive-drop-table-hangs-postgres-metastore.html




--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira