linux hive创建数据库失败,linux下postgres创建hive数据库

操作步骤

#登录

[[email protected] ~]# su postgres

bash-4.2$ psql -U postgres

could not change directory to "/root"

psql (9.2.24)

Type "help" for help.

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+-----------+---------+-------+-----------------------

metastore | hive | UTF8 | C | C |

postgres | postgres | SQL_ASCII | C | C |

scm | scm | UTF8 | C | C |

template0 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C | C |

(5 rows)

#删除存留的hive数据库

postgres=# drop database metastore;

DROP DATABASE

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+-----------+---------+-------+-----------------------

postgres | postgres | SQL_ASCII | C | C |

scm | scm | UTF8 | C | C |

template0 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C | C |

(4 rows)

## 创建数据库，用户是hive

postgres=# createdb -U hive metastore

postgres-# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+-----------+---------+-------+-----------------------

postgres | postgres | SQL_ASCII | C | C |

scm | scm | UTF8 | C | C |

template0 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C | C |

(4 rows)

## 拥有者

postgres=# create database metastore owner hive;

CREATE DATABASE

postgres=# \l

List of databases

Name | Owner | Encoding | Collate | Ctype | Access privileges

-----------+----------+-----------+---------+-------+-----------------------

metastore | hive | UTF8 | C | C |

postgres | postgres | SQL_ASCII | C | C |

scm | scm | UTF8 | C | C |

template0 | postgres | SQL_ASCII | C | C | =c/postgres +

| | | | | postgres=CTc/postgres

template1 | postgres | UTF8 | C | C |

(5 rows)

## 权限

postgres=# grant all on database metastore to hive;

GRANT

postgres=#

原文：https://www.cnblogs.com/JuncaiF/p/12374259.html