Styjun

Passwordless authentication - how invalidate login code

Are "confidant" and "confident" homophones?

How to factor a fourth degree polynomial

Does the Milky Way orbit around anything?

Groups where no elements commute except for the trivial cases

Does the sensor of a dslr count the number of photons that hits it?

How did the IEC decide to create kibibytes?

Implicit conversion between decimals with different precisions

What purpose does mercury dichloride have in fireworks?

Is this car delivery via Ebay Motors on Craigslist a scam?

Why do Martians have to wear space helmets?

Why do most airliners have underwing engines, while business jets have rear-mounted engines?

When moving a unique_ptr into a lambda, why is it not possible to call reset?

Why do we need a bootloader separate from our application program in microcontrollers?

What is this airplane with small wings at different angles seen at Paphos Airport?

What's the difference between a type and a kind?

I'm feeling like my character doesn't fit the campaign

Possibility to correct pitch from digital versions of records with the hole not centered

Is reasonable to assume that the 食 in 月食/日食 can be interpreted as the sun/moon being "eaten" during an eclipse?

Gory anime with pink haired girl escaping an asylum

What is the shape of the upper boundary of water hitting a screen?

How to reclaim personal item I've lent to the office without burning bridges?

Taking my Ph.D. advisor out for dinner after graduation

Who goes first? Person disembarking bus or the bicycle?

Redshift query not returning certain columns

Very bad performance of UNION select query in RedShift / ParAccelData value “0” has invalid format error in redshiftTable scan on Redshift table even with sort keysRedshift time-series table loading questionsAWS Redshift Query Plan WarningRedshift cluster bigger because of running queryDifficulty in constructing SQL query for RedshiftWeird error returned by date_trunc() in RedshiftQuerying data from redshift table, column of data type timestampRedshift window function for change in column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have encountered a strange error on on of our tables ("nav") with the following structure:

position | character varying(400)
timestamp | timestamp without time zone 

If I run the following query, I get back, as expected, all matching results for the 2 columns:

SELECT * FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

However, if I run the following query, I get back the same number of results, but each field/row is empty:

SELECT position FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

I run the same query on similar tables and experience no issues. Any ideas as to what may be causing the second to return blanks in the rows please?

amazon-web-services amazon-redshift

share|improve this question

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you share sample data, and both outputs
  
  – mdem7
  Mar 25 at 16:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This sounds to me like an issue with the tool you're using to query Redshift rather than an issue with Redshift itself. What tool are you using?
  
  – Nathan Griffiths
  Mar 25 at 19:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @NathanGriffiths I am using psql
  
  – RunLoop
  Mar 26 at 3:14
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I'm not able to replicate this using Aginity Workbench for Redshift, the above queries always return values (although I have no idea what your data looks like). Possibly this is an artifact of using psql with Redshift, I'm not sure. What happens if you run the following: select "position" from nav ?
  
  – Nathan Griffiths
  Mar 26 at 6:55
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @NathanGriffiths I tried it but same result unfortunately. Strange thing is we have another table that is very similar - same field types, names and values and for it the queries all run fine. It is just this one table.
  
  – RunLoop
  Mar 26 at 8:51
  

  
  
  
  

 | 
show 1 more comment

0

I have encountered a strange error on on of our tables ("nav") with the following structure:

position | character varying(400)
timestamp | timestamp without time zone 

If I run the following query, I get back, as expected, all matching results for the 2 columns:

SELECT * FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

However, if I run the following query, I get back the same number of results, but each field/row is empty:

SELECT position FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

I run the same query on similar tables and experience no issues. Any ideas as to what may be causing the second to return blanks in the rows please?

amazon-web-services amazon-redshift

share|improve this question

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you share sample data, and both outputs
  
  – mdem7
  Mar 25 at 16:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This sounds to me like an issue with the tool you're using to query Redshift rather than an issue with Redshift itself. What tool are you using?
  
  – Nathan Griffiths
  Mar 25 at 19:04
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @NathanGriffiths I am using psql
  
  – RunLoop
  Mar 26 at 3:14
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I'm not able to replicate this using Aginity Workbench for Redshift, the above queries always return values (although I have no idea what your data looks like). Possibly this is an artifact of using psql with Redshift, I'm not sure. What happens if you run the following: select "position" from nav ?
  
  – Nathan Griffiths
  Mar 26 at 6:55
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @NathanGriffiths I tried it but same result unfortunately. Strange thing is we have another table that is very similar - same field types, names and values and for it the queries all run fine. It is just this one table.
  
  – RunLoop
  Mar 26 at 8:51
  

  
  
  
  

 | 
show 1 more comment

I have encountered a strange error on on of our tables ("nav") with the following structure:

position | character varying(400)
timestamp | timestamp without time zone 

If I run the following query, I get back, as expected, all matching results for the 2 columns:

SELECT * FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

However, if I run the following query, I get back the same number of results, but each field/row is empty:

SELECT position FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

I run the same query on similar tables and experience no issues. Any ideas as to what may be causing the second to return blanks in the rows please?

amazon-web-services amazon-redshift

share|improve this question

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

position | character varying(400)
timestamp | timestamp without time zone 

SELECT * FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

SELECT position FROM nav WHERE timestamp >= '2019-03-24' AND timestamp < '2019-03-25';

share|improve this question

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

share|improve this question

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

edited Mar 25 at 20:52

John Rotenstein

88.2k88 gold badges101101 silver badges151151 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges

asked Mar 25 at 15:50

RunLoopRunLoop

10k2020 gold badges8181 silver badges134134 bronze badges