You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airflow.apache.org by Ruslan Dautkhanov <da...@gmail.com> on 2017/03/18 02:56:54 UTC
SQLOperator?
I can't find references to SQLOperator neither in the source code nor in
the API Reference.
Although it is mentioned in Concepts page :
https://github.com/apache/incubator-airflow/blob/master/docs/concepts.rst#operators
- SqlOperator - executes a SQL command
Sorry for basic questions - just started using Airflow this week.
Did it got replaced with something else? If so what that is?
Thanks,
Ruslan Dautkhanov
Re: SQLOperator?
Posted by Ruslan Dautkhanov <da...@gmail.com>.
Does this documentation change look good ?
https://github.com/apache/incubator-airflow/pull/2168/files
--
Ruslan Dautkhanov
On Sat, Mar 18, 2017 at 2:59 PM, Ruslan Dautkhanov <da...@gmail.com>
wrote:
> I just noticed that there is already a Oracle_Operator
>
> https://github.com/apache/incubator-airflow/blob/master/
> airflow/operators/oracle_operator.py
>
> "Concepts" page has to be updated probably to reflect that there is no
> SQLOpartor.
>
> Yep, I have cx_Oracle installed.
>
> Thanks Alex and Boris.
>
>
>
> --
> Ruslan Dautkhanov
>
> On Sat, Mar 18, 2017 at 12:20 PM, Boris Tyukin <bo...@boristyukin.com>
> wrote:
>
>> >>I guess I will have to call OracleHook from PythonOperator?
>>
>> that's what I do! works fine. do not forget to install oracle_cx library
>> https://pypi.python.org/pypi/cx_Oracle/5.2.1
>>
>> you can also create your own operator using one of existing ones as an
>> example
>>
>> On Fri, Mar 17, 2017 at 11:49 PM, Ruslan Dautkhanov <dautkhanov@gmail.com
>> >
>> wrote:
>>
>> > Thanks Alex
>> >
>> > I did notice MySQL one
>> >
>> > We are working with Oracle
>> >
>> > I guess I will have to call OracleHook from PythonOperator?
>> >
>> >
>> >
>> > On Fri, Mar 17, 2017 at 9:25 PM Alex Guziel <alex.guziel@airbnb.com.
>> > invalid>
>> > wrote:
>> >
>> > > I'm not sure if that one went away but there are different SQL
>> operators,
>> > > like MySqlOperator, MsSqlOperator, etc. that I see.
>> > >
>> > > Best,
>> > > Alex
>> > >
>> > > On Fri, Mar 17, 2017 at 7:56 PM, Ruslan Dautkhanov <
>> dautkhanov@gmail.com
>> > >
>> > > wrote:
>> > >
>> > > > I can't find references to SQLOperator neither in the source code
>> nor
>> > in
>> > > > the API Reference.
>> > > >
>> > > > Although it is mentioned in Concepts page :
>> > > >
>> > > > https://github.com/apache/incubator-airflow/blob/master/
>> > > > docs/concepts.rst#operators
>> > > >
>> > > >
>> > > >
>> > > > - SqlOperator - executes a SQL command
>> > > >
>> > > > Sorry for basic questions - just started using Airflow this week.
>> > > > Did it got replaced with something else? If so what that is?
>> > > >
>> > > >
>> > > >
>> > > > Thanks,
>> > > > Ruslan Dautkhanov
>> > > >
>> > >
>> >
>>
>
>
Re: SQLOperator?
Posted by Ruslan Dautkhanov <da...@gmail.com>.
I just noticed that there is already a Oracle_Operator
https://github.com/apache/incubator-airflow/blob/master/airflow/operators/oracle_operator.py
"Concepts" page has to be updated probably to reflect that there is no
SQLOpartor.
Yep, I have cx_Oracle installed.
Thanks Alex and Boris.
--
Ruslan Dautkhanov
On Sat, Mar 18, 2017 at 12:20 PM, Boris Tyukin <bo...@boristyukin.com>
wrote:
> >>I guess I will have to call OracleHook from PythonOperator?
>
> that's what I do! works fine. do not forget to install oracle_cx library
> https://pypi.python.org/pypi/cx_Oracle/5.2.1
>
> you can also create your own operator using one of existing ones as an
> example
>
> On Fri, Mar 17, 2017 at 11:49 PM, Ruslan Dautkhanov <da...@gmail.com>
> wrote:
>
> > Thanks Alex
> >
> > I did notice MySQL one
> >
> > We are working with Oracle
> >
> > I guess I will have to call OracleHook from PythonOperator?
> >
> >
> >
> > On Fri, Mar 17, 2017 at 9:25 PM Alex Guziel <alex.guziel@airbnb.com.
> > invalid>
> > wrote:
> >
> > > I'm not sure if that one went away but there are different SQL
> operators,
> > > like MySqlOperator, MsSqlOperator, etc. that I see.
> > >
> > > Best,
> > > Alex
> > >
> > > On Fri, Mar 17, 2017 at 7:56 PM, Ruslan Dautkhanov <
> dautkhanov@gmail.com
> > >
> > > wrote:
> > >
> > > > I can't find references to SQLOperator neither in the source code nor
> > in
> > > > the API Reference.
> > > >
> > > > Although it is mentioned in Concepts page :
> > > >
> > > > https://github.com/apache/incubator-airflow/blob/master/
> > > > docs/concepts.rst#operators
> > > >
> > > >
> > > >
> > > > - SqlOperator - executes a SQL command
> > > >
> > > > Sorry for basic questions - just started using Airflow this week.
> > > > Did it got replaced with something else? If so what that is?
> > > >
> > > >
> > > >
> > > > Thanks,
> > > > Ruslan Dautkhanov
> > > >
> > >
> >
>
Re: SQLOperator?
Posted by Boris Tyukin <bo...@boristyukin.com>.
>>I guess I will have to call OracleHook from PythonOperator?
that's what I do! works fine. do not forget to install oracle_cx library
https://pypi.python.org/pypi/cx_Oracle/5.2.1
you can also create your own operator using one of existing ones as an
example
On Fri, Mar 17, 2017 at 11:49 PM, Ruslan Dautkhanov <da...@gmail.com>
wrote:
> Thanks Alex
>
> I did notice MySQL one
>
> We are working with Oracle
>
> I guess I will have to call OracleHook from PythonOperator?
>
>
>
> On Fri, Mar 17, 2017 at 9:25 PM Alex Guziel <alex.guziel@airbnb.com.
> invalid>
> wrote:
>
> > I'm not sure if that one went away but there are different SQL operators,
> > like MySqlOperator, MsSqlOperator, etc. that I see.
> >
> > Best,
> > Alex
> >
> > On Fri, Mar 17, 2017 at 7:56 PM, Ruslan Dautkhanov <dautkhanov@gmail.com
> >
> > wrote:
> >
> > > I can't find references to SQLOperator neither in the source code nor
> in
> > > the API Reference.
> > >
> > > Although it is mentioned in Concepts page :
> > >
> > > https://github.com/apache/incubator-airflow/blob/master/
> > > docs/concepts.rst#operators
> > >
> > >
> > >
> > > - SqlOperator - executes a SQL command
> > >
> > > Sorry for basic questions - just started using Airflow this week.
> > > Did it got replaced with something else? If so what that is?
> > >
> > >
> > >
> > > Thanks,
> > > Ruslan Dautkhanov
> > >
> >
>
Re: SQLOperator?
Posted by Ruslan Dautkhanov <da...@gmail.com>.
Thanks Alex
I did notice MySQL one
We are working with Oracle
I guess I will have to call OracleHook from PythonOperator?
On Fri, Mar 17, 2017 at 9:25 PM Alex Guziel <al...@airbnb.com.invalid>
wrote:
> I'm not sure if that one went away but there are different SQL operators,
> like MySqlOperator, MsSqlOperator, etc. that I see.
>
> Best,
> Alex
>
> On Fri, Mar 17, 2017 at 7:56 PM, Ruslan Dautkhanov <da...@gmail.com>
> wrote:
>
> > I can't find references to SQLOperator neither in the source code nor in
> > the API Reference.
> >
> > Although it is mentioned in Concepts page :
> >
> > https://github.com/apache/incubator-airflow/blob/master/
> > docs/concepts.rst#operators
> >
> >
> >
> > - SqlOperator - executes a SQL command
> >
> > Sorry for basic questions - just started using Airflow this week.
> > Did it got replaced with something else? If so what that is?
> >
> >
> >
> > Thanks,
> > Ruslan Dautkhanov
> >
>
Re: SQLOperator?
Posted by Alex Guziel <al...@airbnb.com.INVALID>.
I'm not sure if that one went away but there are different SQL operators,
like MySqlOperator, MsSqlOperator, etc. that I see.
Best,
Alex
On Fri, Mar 17, 2017 at 7:56 PM, Ruslan Dautkhanov <da...@gmail.com>
wrote:
> I can't find references to SQLOperator neither in the source code nor in
> the API Reference.
>
> Although it is mentioned in Concepts page :
>
> https://github.com/apache/incubator-airflow/blob/master/
> docs/concepts.rst#operators
>
>
>
> - SqlOperator - executes a SQL command
>
> Sorry for basic questions - just started using Airflow this week.
> Did it got replaced with something else? If so what that is?
>
>
>
> Thanks,
> Ruslan Dautkhanov
>