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