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

Table data is not displayed in Column Format.

edited September 17 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
    Accepted 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

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