The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Failed to create database VMart

Hi,

I followed this url https://community.dev.hp.com/t5/Vertica-Forum/quot-failed-to-create-database-VMart-quot-using-VMware-CE-v-7-0/td-p/214303 and tried the below mentioned command for installing VMart database but I still could not solve the problem.

[[email protected] sbin]$ /opt/vertica/sbin/install_example VMart
Installing VMart example database
Thu May 21 09:54:46 EDT 2015
Creating Database
Failed to create database VMart
[[email protected] sbin]$

 

Kindly suggest how can i solve the above problem.

 

Thanks

 

Ujjwal

Comments

  • SruthiASruthiA Employee

    Did you check if there is VMart folder  in /home/dbadmin?

     

     

    -Regards,

     Sruthi

  • There is nothing related with VMart inside /home/dbadmin/

     

    [[email protected] sbin]$ cd /home/dbadmin

    [[email protected] ~]$ ls
    Desktop  Documents  Downloads  Music  Pictures  Public  Templates  Videos
    [[email protected] ~]$

     

    But If you check from admintools it shows VMART database

  • Hello Shruti,

    This is what I did. Since there were already an existing databse named VMart but it was not showing all the tables and schemas inside VMART database. As a result I tried following  steps

    :-

    First

     

    1. [[email protected] ~]$ admintools

    2. Select 6 CONFIGURATION MENU

    3. Select 7 DROP DATABASE

    4. Selected M Menu

    5. Selected E Exit

     

    Second

     

    [[email protected] ~]$ /opt/vertica/sbin/install_example VMart
    Installing VMart example database
    Thu May 21 11:13:00 EDT 2015
    Creating Database
    Completed
    Generating Data. This may take a few minutes.
    Completed
    Creating schema
    Completed
    Loading 5 million rows of data. Please stand by.
    Completed
    Removing generated data files
    Example database creation complete

    Log is located in /opt/vertica/examples/log/ExampleInstall.txt

    Thu May 21 11:14:11 EDT 2015
    [[email protected] ~]$

     

    And It now shows all the tables

     

    [[email protected] ~]$ vsql
    Welcome to vsql, the Vertica Analytic Database interactive terminal.

    Type:  \h or \? for help with vsql commands
           \g or terminate with semicolon to execute query
           \q to quit

    dbadmin=> \d
                              List of tables
        Schema    |         Name          | Kind  |  Owner  | Comment
    --------------+-----------------------+-------+---------+---------
     online_sales | call_center_dimension | table | dbadmin |
     online_sales | online_page_dimension | table | dbadmin |
     online_sales | online_sales_fact     | table | dbadmin |
     public       | customer_dimension    | table | dbadmin |
     public       | date_dimension        | table | dbadmin |
     public       | employee_dimension    | table | dbadmin |
     public       | inventory_fact        | table | dbadmin |
     public       | product_dimension     | table | dbadmin |
     public       | promotion_dimension   | table | dbadmin |
     public       | shipping_dimension    | table | dbadmin |
     public       | vendor_dimension      | table | dbadmin |
     public       | warehouse_dimension   | table | dbadmin |
     store        | store_dimension       | table | dbadmin |
     store        | store_orders_fact     | table | dbadmin |
     store        | store_sales_fact      | table | dbadmin |
    (15 rows)

    dbadmin=>

     

     

  • SruthiASruthiA Employee

    great to know that it was solved

  • Thank you Shruti for support

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.