Q&A BY TAG 'select query'

You must sign in to ask a question. If you do not have an account, you can register here

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

select query flatten ARRAY missing records JSON join

Passing case statement as subquery in select statement.
answered 22-07-2021 17:57:43 -0400

We are automating function to get prior two business days excluding weekends using below logic : select * from dw_vdb.cib360_bv_daily where as_of_date in (select case getdayofweek(current_date) when 3 then addday(current_date, -4) when 2 then addday(c...

Answers: 3

Denodo 7.0 Select Query CASE

GetSession not working outside of the VDP
answered 11-03-2021 07:55:36 -0500

I had the following script and then various views based off this script working in the VDP but then when I tried to run a dervied view from a tool like DBeaver everything is coming up blank because the GETSESSION function is not returning a value. Is...

Answers: 1

select query vdp getsession dbeaver

creating a base view off of a working script in VQL Shell
answered 10-03-2021 10:04:35 -0500

I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGH...

Answers: 1

select query Vql shell Create Base View

Create new records per column value
answered 28-05-2019 20:21:09 -0400

I have a table like this: Name job_1 job_2 job_n Paul Architect null null Eva Nurse MD null John Lawyer Seller Writer I need to create a ne...

Answers: 1

Select Query

Create Base view from SQL query
answered 15-02-2019 07:24:08 -0500

Hello there! I'm tottaly new on Data Virtualization and Denodo I'm trying to create my first view from SQL query (PostgresSQL) Would you guys could help me o that? <image src="https://drive.google.com/open?id=0B5D_BLEYhiEMU2lXNmZXY09CUHRpM3R0VVNx...

Answers: 1

Denodo Express PostgreSQL Select Query

Java Heap space error while running query
answered 13-02-2019 00:07:14 -0500

Hello, while executing select on a view, I am getting the error- "Finished with error: Error occurred in server thread; nested exception is: java.lang.OutOfMemoryError: Java heap space" Can you please help me on the issue, where I can increase the hea...

Answers: 1

Base view java Select Query 'Java heap space'

Using Regexp_like in Case in Select
answered 27-09-2018 11:26:31 -0400

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

Answers: 2

REGEXP_LIKE Select Query CASE

select top 2 * from table
answered 29-04-2016 21:39:06 -0400

Hi Team, Am looking for to query top few rows from the tables. I used below query select top 2 * from table . Please correct the query. Thanks Saraswathi C

Answers: 1

Select Query