r4ntix opened a new issue, #3874:
URL: https://github.com/apache/arrow-datafusion/issues/3874

   **Is your feature request related to a problem or challenge? Please describe 
what you are trying to do.**
   create view, then query from the view fails:
   ```sql
   /* benchmark q15 sql */
   create view revenue0 (supplier_no, total_revenue) as
   select
        l_suppkey,
        sum(l_extendedprice * (1 - l_discount))
   from
        lineitem
   where
        l_shipdate >= date '1996-01-01'
        and l_shipdate < date '1996-01-01' + interval '3' month
   group by
        l_suppkey;
   
   select
        s_suppkey,
        s_name,
        s_address,
        s_phone,
        total_revenue
   from
        supplier,
        revenue0
   where
        s_suppkey = supplier_no
        and total_revenue = (
                select
                        max(total_revenue)
                from
                        revenue0
        )
   order by
        s_suppkey;
   
   drop view revenue0;
   ```
   
   ```
   Error: Internal("logical plan to_proto unsupported table provider Any { .. 
}")
   ```
   
   This problem was found in arrow-ballista's benchmarks test: 
https://github.com/apache/arrow-ballista/issues/372
   
   **Describe the solution you'd like**
   Add view table scan support
   
   **Describe alternatives you've considered**
   A clear and concise description of any alternative solutions or features 
you've considered.
   
   **Additional context**
   Add any other context or screenshots about the feature request here.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to