Auto increment a table column using python

تعرفه تبلیغات در سایت
عنوان عکس عنوان عکس عنوان عکس عنوان عکس
عنوان عکس عنوان عکس عنوان عکس عنوان عکس
عنوان عکس عنوان عکس عنوان عکس عنوان عکس
عنوان عکس عنوان عکس عنوان عکس عنوان عکس
عنوان عکس عنوان عکس عنوان عکس عنوان عکس

آرشیو مطالب

جستجوگر

یافته ها در جستجو

    امکانات وب

    برچسب ها

    Vote count: 0

    In Hive I have a table called test. In this table I want to have 5 columns.

    ID, start_time, end_time, min_value, max_value.
    

    Now using Pyspark I want to populate this table.

    I am doing like below in my python file:

    start_time='4/5/2017'
    end_time='5/4/2017'
    min_value='1'
    max_value='100'
    
    sqlContext.sql("insert into table testing.test select '{}','{}','{}','{}','{}'".format(id,start_time,end_time,min_value,max_value))
    

    In this above script start_time, end_time, min_value, max_value I will get these values as part of the script.

    Now what I want is the column should be Auto incremented when ever there is an insert statement is being executed then there should be id value added to it.

    Is it possible to that using python? if yes then

    How can I do auto increment for column ID in my script

    asked 49 secs ago

  • مطالب مرتبط
  • Performance drops when using modulo on double
  • Repeating for loop within a function Python 3
  • Creating new column with two date conditions from old column R
  • Android : There's no route in routing table, but still online. Why?
  • How to get id from SelectField in material-ui using react?
  • Pandas and R inconsistency in calculating column size
  • نویسنده : استخدام کار بازدید : 67 تاريخ : شنبه 30 ارديبهشت 1396 ساعت: 6:01
    برچسب‌ها :