Postgres - support for DATE data type in FilterBox

2018-10-24 Thread Deenar Toraskar 
Greetings to the superset community. I have been using the tool with
SQLLite and have recently moved to using PostGres as it is our target
production database/report store.

I have columns of type Date that are not handled correctly and am at a loss
to find a solution. I have searched existing issues and wanted to run it
past the distribution list before filing an issue. (not sure if this is the
convention or i should file an issue first)

The DATE column fields seem to be treated as BIGINT, though the SQLLab
queries handle them correctly.
so  2018-01-01 values in the database are rendered as 151476480 in the
FilterBox and any filter actions fail as the SQL generated is "WHERE date
IN (151476480)"

operator does not exist: date = bigint LINE 4: WHERE date IN
(151476480) ^ HINT: No operator matches the given name and argument
type(s). You might need to add explicit type casts.

I tried putting in to_date('{}', '-MM-DD') as the date expression, but
this only works for "Time related form attributes" not the filter box
visualization where the date values come from the database. The other
charts viz. Tables render date columns fine.

Any assistance would be appreciated.

Regards
Deenar

[SIP-0] Vote

2018-10-24 Thread Beto Dealmeida 

Hi, all.

I would like to call a vote on SIP-0, "Superset Improvement Proposals":

https://github.com/apache/incubator-superset/issues/5602

Beto

Re: [SIP-0] Vote

2018-10-24 Thread Krist Wongsuphasawat 
+1

On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
wrote:

> Hi, all.
>
> I would like to call a vote on SIP-0, "Superset Improvement Proposals":
>
> https://github.com/apache/incubator-superset/issues/5602
>
> Beto
>
>

-- 

*Krist Wongsuphasawat, PhD*
http://kristw.yellowpigz.com

Re: [SIP-0] Vote

2018-10-24 Thread John Bodley 
+1

On Wed, Oct 24, 2018 at 2:02 PM Krist Wongsuphasawat 
wrote:

> +1
>
> On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> wrote:
>
> > Hi, all.
> >
> > I would like to call a vote on SIP-0, "Superset Improvement Proposals":
> >
> > https://github.com/apache/incubator-superset/issues/5602
> >
> > Beto
> >
> >
>
> --
>
> *Krist Wongsuphasawat, PhD*
> http://kristw.yellowpigz.com
>

Re: [SIP-0] Vote

2018-10-24 Thread Chris Williams 
+1

Chris

Data Visualization
San Francisco


On Wed, Oct 24, 2018 at 2:29 PM John Bodley 
wrote:

> +1
>
> On Wed, Oct 24, 2018 at 2:02 PM Krist Wongsuphasawat <
> krist.wo...@gmail.com>
> wrote:
>
> > +1
> >
> > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> > wrote:
> >
> > > Hi, all.
> > >
> > > I would like to call a vote on SIP-0, "Superset Improvement Proposals":
> > >
> > > https://github.com/apache/incubator-superset/issues/5602
> > >
> > > Beto
> > >
> > >
> >
> > --
> >
> > *Krist Wongsuphasawat, PhD*
> > http://kristw.yellowpigz.com
> >
>

Re: [SIP-0] Vote

2018-10-24 Thread Maxime Beauchemin 
+1

On Wed, Oct 24, 2018 at 2:30 PM Chris Williams
 wrote:

> +1
>
> Chris
>
> Data Visualization
> San Francisco
>
>
> On Wed, Oct 24, 2018 at 2:29 PM John Bodley  .invalid>
> wrote:
>
> > +1
> >
> > On Wed, Oct 24, 2018 at 2:02 PM Krist Wongsuphasawat <
> > krist.wo...@gmail.com>
> > wrote:
> >
> > > +1
> > >
> > > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> > > wrote:
> > >
> > > > Hi, all.
> > > >
> > > > I would like to call a vote on SIP-0, "Superset Improvement
> Proposals":
> > > >
> > > > https://github.com/apache/incubator-superset/issues/5602
> > > >
> > > > Beto
> > > >
> > > >
> > >
> > > --
> > >
> > > *Krist Wongsuphasawat, PhD*
> > > http://kristw.yellowpigz.com
> > >
> >
>

Re: [SIP-0] Vote

2018-10-24 Thread Maxime Beauchemin 
FYI
https://community.apache.org/committers/voting.html

On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
wrote:

> Hi, all.
>
> I would like to call a vote on SIP-0, "Superset Improvement Proposals":
>
> https://github.com/apache/incubator-superset/issues/5602
>
> Beto
>
>

Re: [SIP-0] Vote

2018-10-24 Thread Eli Brumbaugh 
+1
On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
maximebeauche...@gmail.com> wrote:

> FYI
> https://community.apache.org/committers/voting.html
>
> On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> wrote:
>
> > Hi, all.
> >
> > I would like to call a vote on SIP-0, "Superset Improvement Proposals":
> >
> > https://github.com/apache/incubator-superset/issues/5602
> >
> > Beto
> >
> >
>
-- 
Eli Sebastian Brumbaugh
Design Lead  |  Data Platform  |  Data UX
Indigenous@ Diversity Group Founder

Re: [SIP-0] Vote

2018-10-24 Thread Fabian Menges 
+1

On Wed, Oct 24, 2018 at 5:38 PM Eli Brumbaugh
 wrote:

> +1
> On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
> maximebeauche...@gmail.com> wrote:
>
> > FYI
> > https://community.apache.org/committers/voting.html
> >
> > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> > wrote:
> >
> > > Hi, all.
> > >
> > > I would like to call a vote on SIP-0, "Superset Improvement Proposals":
> > >
> > > https://github.com/apache/incubator-superset/issues/5602
> > >
> > > Beto
> > >
> > >
> >
> --
> Eli Sebastian Brumbaugh
> Design Lead  |  Data Platform  |  Data UX
> Indigenous@ Diversity Group Founder
>

Re: [SIP-0] Vote

2018-10-24 Thread Michelle Thomas 
+1

On Wed, Oct 24, 2018 at 2:54 PM Fabian Menges 
wrote:

> +1
>
> On Wed, Oct 24, 2018 at 5:38 PM Eli Brumbaugh
>  wrote:
>
> > +1
> > On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
> > maximebeauche...@gmail.com> wrote:
> >
> > > FYI
> > > https://community.apache.org/committers/voting.html
> > >
> > > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida 
> > > wrote:
> > >
> > > > Hi, all.
> > > >
> > > > I would like to call a vote on SIP-0, "Superset Improvement
> Proposals":
> > > >
> > > > https://github.com/apache/incubator-superset/issues/5602
> > > >
> > > > Beto
> > > >
> > > >
> > >
> > --
> > Eli Sebastian Brumbaugh
> > Design Lead  |  Data Platform  |  Data UX
> > Indigenous@ Diversity Group Founder
> >
>

Re: [SIP-0] Vote

2018-10-24 Thread Timi Fasubaa 
+1
On Wed, Oct 24, 2018 at 3:06 PM Michelle Thomas
 wrote:

> +1
>
> On Wed, Oct 24, 2018 at 2:54 PM Fabian Menges  >
> wrote:
>
> > +1
> >
> > On Wed, Oct 24, 2018 at 5:38 PM Eli Brumbaugh
> >  wrote:
> >
> > > +1
> > > On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
> > > maximebeauche...@gmail.com> wrote:
> > >
> > > > FYI
> > > > https://community.apache.org/committers/voting.html
> > > >
> > > > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida <
> robe...@dealmeida.net>
> > > > wrote:
> > > >
> > > > > Hi, all.
> > > > >
> > > > > I would like to call a vote on SIP-0, "Superset Improvement
> > Proposals":
> > > > >
> > > > > https://github.com/apache/incubator-superset/issues/5602
> > > > >
> > > > > Beto
> > > > >
> > > > >
> > > >
> > > --
> > > Eli Sebastian Brumbaugh
> > > Design Lead  |  Data Platform  |  Data UX
> > > Indigenous@ Diversity Group Founder
> > >
> >
>

Re: [SIP-0] Vote

2018-10-24 Thread Vyl Chiang 
+1
Vyl Chiang
Product
650.279.1185




On Wed, Oct 24, 2018 at 5:27 PM Timi Fasubaa
 wrote:

> +1
> On Wed, Oct 24, 2018 at 3:06 PM Michelle Thomas
>  wrote:
>
> > +1
> >
> > On Wed, Oct 24, 2018 at 2:54 PM Fabian Menges
>  > >
> > wrote:
> >
> > > +1
> > >
> > > On Wed, Oct 24, 2018 at 5:38 PM Eli Brumbaugh
> > >  wrote:
> > >
> > > > +1
> > > > On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
> > > > maximebeauche...@gmail.com> wrote:
> > > >
> > > > > FYI
> > > > > https://community.apache.org/committers/voting.html
> > > > >
> > > > > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida <
> > robe...@dealmeida.net>
> > > > > wrote:
> > > > >
> > > > > > Hi, all.
> > > > > >
> > > > > > I would like to call a vote on SIP-0, "Superset Improvement
> > > Proposals":
> > > > > >
> > > > > > https://github.com/apache/incubator-superset/issues/5602
> > > > > >
> > > > > > Beto
> > > > > >
> > > > > >
> > > > >
> > > > --
> > > > Eli Sebastian Brumbaugh
> > > > Design Lead  |  Data Platform  |  Data UX
> > > > Indigenous@ Diversity Group Founder
> > > >
> > >
> >
>

Re: [SIP-0] Vote

2018-10-24 Thread Jeff Feng 
+1

On Wed, Oct 24, 2018 at 3:29 PM Vyl Chiang  wrote:

> +1
> Vyl Chiang
> Product
> 650.279.1185
>
> 
>
>
> On Wed, Oct 24, 2018 at 5:27 PM Timi Fasubaa
>  wrote:
>
> > +1
> > On Wed, Oct 24, 2018 at 3:06 PM Michelle Thomas
> >  wrote:
> >
> > > +1
> > >
> > > On Wed, Oct 24, 2018 at 2:54 PM Fabian Menges
> >  > > >
> > > wrote:
> > >
> > > > +1
> > > >
> > > > On Wed, Oct 24, 2018 at 5:38 PM Eli Brumbaugh
> > > >  wrote:
> > > >
> > > > > +1
> > > > > On Wed, Oct 24, 2018 at 2:37 PM Maxime Beauchemin <
> > > > > maximebeauche...@gmail.com> wrote:
> > > > >
> > > > > > FYI
> > > > > > https://community.apache.org/committers/voting.html
> > > > > >
> > > > > > On Wed, Oct 24, 2018 at 1:59 PM Beto Dealmeida <
> > > robe...@dealmeida.net>
> > > > > > wrote:
> > > > > >
> > > > > > > Hi, all.
> > > > > > >
> > > > > > > I would like to call a vote on SIP-0, "Superset Improvement
> > > > Proposals":
> > > > > > >
> > > > > > > https://github.com/apache/incubator-superset/issues/5602
> > > > > > >
> > > > > > > Beto
> > > > > > >
> > > > > > >
> > > > > >
> > > > > --
> > > > > Eli Sebastian Brumbaugh
> > > > > Design Lead  |  Data Platform  |  Data UX
> > > > > Indigenous@ Diversity Group Founder
> > > > >
> > > >
> > >
> >
>


-- 

*Jeff Feng*
Product Lead
m: (949)-610-5108
twitter: @jtfeng