How to get command line bigquery output from java

Question

Query

SELECT column_name, data_type
FROM `bigquery-public-data.samples.INFORMATION_SCHEMA.COLUMNS` 
WHERE table_name = 'shakespeare'

When I from command line output looks formatted

+-------------+-----------+
| column_name | data_type |
+-------------+-----------+
| word        | STRING    |
| word_count  | INT64     |
| corpus      | STRING    |
| corpus_date | INT64     |
+-------------+-----------+

When I run from java, get a json response. Is there any way to print command line look a like output using java code?

Graham Polley · Accepted Answer · 2020-07-02 22:48:47Z

1

No, not without doing some parsing/formatting yourself. What you are seeing in this example is the BigQuery CLI tool formatting the JSON response from the API (it will always return JSON) using Python under the hood. You'd need to do the same in your Java application. There might be libs that do this already, so have a look around.

answered Jul 2, 2020 at 22:48

Graham Polley

14.8k9 gold badges54 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get command line bigquery output from java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related