User Profile

Collapse

Profile Sidebar

Collapse
manyatha
manyatha
Last Activity: May 20 '17, 03:02 AM
Joined: May 9 '17
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • manyatha
    started a topic how to add two files using python
    in Python

    how to add two files using python

    input1:create external table db.emp(id int,name string)
    row formatted fields terminated by ','
    location 'hadfs:.../';

    create external table db.emp1(id int,name string)
    row formatted fields terminated by ','
    location 'hadfs:.../';

    input2:create external table db.emp(id int,name string)
    row formatted fields terminated by ','
    location 'hadfs:.../';;
    create table db.emp1(id...
    See more | Go to post
    • manyatha
      replied to How to create hive comparable table statement using Python
      in Python
      Thank you it's help full.but currently am getting data as file,so there I need to convert column names and data types I have done.but finally create statement unable to insert last few line.if any suggestions it should be appreciated.
      See more | Go to post

        Leave a comment:

      • manyatha
        started a topic How to create hive comparable table statement using Python
        in Python

        How to create hive comparable table statement using Python

        I/p:SQL server file is input
        I/p:Hive create statements
        I tried with this code but unable to reach some portion.please help and am new to Python
        Eg create statement

        create external table db.emp
        (
        Name string,
        I'd int,
        Fname string,
        .....,

        )
        ROW FORMAT DELIMITED FIELDS TERMINATED BY '~'


        LOCATION 'usr/bin/...';


        #!/bin/sh
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...