We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Table data is not displayed in Column Format. — Vertica Forum

Table data is not displayed in Column Format.

BhargavBhargav Vertica Customer
edited September 2019 in General Discussion


Hi,
I have a Sample data which consist only 6 rows. Whenever i want to display it in columnar format, it display in text format. I already follow this steps.
1)CREATE FLEX TABLE Sample_Data_1 ();
2)COPY Sample_Data_1 FROM '/tmp/RF_Data_1.csv' PARSER fcsvparser();
3)SELECT maptostring(raw) FROM Sample_Data_1;
4)SELECT compute_flextable_keys_and_build_view('Sample_Data_1');

Both screenshot (Sample Data & Its Result) are attached below.
Bhargav,
Regards

Best Answer

  • emorenoemoreno Employee
    Answer ✓

    Hi,
    You need to
    SELECT build_flextable_view('Sample_Data_1');
    SELECT * from public. Sample_Data_1_view;
    Columnar format is in the view.
    Eugenia

Answers

Leave a Comment

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