Open SQLadmin opened 5 years ago
The results should automatically open the “Output” window, which is part of the Terminal & Debugging pane either to the right or bottom of your editor window.
Run a test query that returns quickly to test - e.g. SELECT 1 On Tue, Oct 30, 2018 at 3:22 AM SqlAdmin notifications@github.com wrote:
I have configured everything and if I select Bigquery: Run as Query it retunes the below infobox. [image: image] https://user-images.githubusercontent.com/16044251/47711647-b1ec7b00-dc5b-11e8-855a-3490231f13af.png
But later I couldn't get any result set for this. To be clear, I don't know where to get the Result window.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/google/vscode-bigquery/issues/4, or mute the thread https://github.com/notifications/unsubscribe-auth/AABIcGtO3awUUscRwwSFqc9yiwUXuHL6ks5uqChlgaJpZM4YBmmL .
--
Matt Silverlock
Customer Engineer
+1 415-736-7456 Mobile
345 Spear Street, San Francisco, CA 94105
I tried this in my VS code
select 1
and the output panel shows this result.
Results for job f46f0e99-22de-4e35-8569-41a4d8556896:
{
"f0_": 1
}
Then I started to run this query.
SELECT
repo_name,
COALESCE(
(
SELECT
language_unnested.bytes
FROM
UNNEST(language) AS language_unnested
WHERE
language_unnested.name = "R"
),
0
) as r_bytes
FROM
`bigquery-public-data`.github_repos.languages
ORDER BY
r_bytes DESC
In BQ console it was running for 0.2 sec. but in VScode, I didn't get any output.
OK - I can reproduce that, but won't have time to investigate a fix this week. It looks like we're swallowing the results somewhere along the way.
On Tue, Oct 30, 2018 at 12:12 PM SqlAdmin notifications@github.com wrote:
I tried this in my VS code
select 1
and the output panel shows this result.
Results for job f46f0e99-22de-4e35-8569-41a4d8556896: { "f0_": 1 }
Then I started to run this query.
SELECT repo_name, COALESCE( ( SELECT language_unnested.bytes FROM UNNEST(language) AS language_unnested WHERE language_unnested.name = "R" ), 0 ) as r_bytes FROM
bigquery-public-data
.github_repos.languages ORDER BY r_bytes DESCIn BQ console it was running for 0.2 sec. but in VScode, I didn't get any output.
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/google/vscode-bigquery/issues/4#issuecomment-434429999, or mute the thread https://github.com/notifications/unsubscribe-auth/AABIcJkBzyk4vYUvbmpC0v0igWG3-yibks5uqKSNgaJpZM4YBmmL .
--
Matt Silverlock
Customer Engineer
+1 415-736-7456 Mobile
345 Spear Street, San Francisco, CA 94105
Ok sure. for your information Im using Vscode on MAC OS
I just saw my VScode, the results are there. But it took hell lot of time :(
I have configured everything and if I select![image](https://user-images.githubusercontent.com/16044251/47711647-b1ec7b00-dc5b-11e8-855a-3490231f13af.png)
Bigquery: Run as Query
it retunes the below infobox.But later I couldn't get any result set for this. To be clear, I don't know where to get the Result window.