kettle - How can I make pentaho spoon auto-create a table? -

-

i having few issues pentaho spoon: want copy table 1 database another.

when click on "copy table" in tool menu, auto creates transformation that. when run these issues:

  1. the truncate table ticked that's why error table not exist.

  2. i have manually un-tick that. error because table not created. have click on sql , execute query. there way automatically it?

  3. third problem pentaho created table not detecting date field, it's putting date type unknown. have manually change varchar. there way fix or default varchar?

the unknown data type typically driver issue. database using , have right driver?

there no way automate creation of table within pdi - it's deliberate not this. integrate pdi tool this, dbdeploy idea.

update there way automatically create tables, can follow blueprint here:

https://github.com/mattcasters/blueprints


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp...
Read more

c++11 - Intel compiler and "cannot have an in-class initializer" when using constexpr -

-
the following test program compiles , runs fine g++. intel icpc (14.0.2) compile , run if use explicit type double instead of template. template version icpc produces error: icpc -g -o2 -i. -std=c++0x -c main.cc -o main.o main.cc(10): error: member of type "const t [9]" cannot have in-class initializer static constexpr t dx_[9] = { test code template<typename t> class myclass { public: static constexpr t dx_[9] = { 1.5, 2.0, -0.5, -0.5, 0.0, 0.5, 0.5, -2.0, -1.5 }; }; template<typename t> constexpr t myclass<t>::dx_[9]; int main(int argc, char *argv[]) { return 0; } // main why receiving error "cannot have in-class initializer" when using constexpr ? this bug of intel compiler, submitted intel , fixed in future versions. also see multiple constexpr bugs , sfinae bug intel c++ compiler 15 , method constexpr bug c++ compiler 15 on intel forums.
Read more

python - get cookie expiry time using the requests library -

-
i trying expiry time of specific cookie retrieve server as: s = requests.session() r = s.get("http://localhost/test") r.cookies this list cookies sent server (i 2 cookies) as: <<class 'requests.cookies.requestscookiejar'>[<cookie phpsessid=cusa6hbtb85li8po argcgev221 localhost.local/>, <cookie websecu=f localhost.local/test>]> when do: r.cookies.keys i get: <bound method requestscookiejar.items of <<class 'requests.cookies.requestscooki ejar'>[cookie(version=0, name='phpsessid', value='30tg9vn9376kmh60ana2essfi3', p ort=none, port_specified=false, domain='localhost.local', domain_specified=false , domain_initial_dot=false, path='/', path_specified=true, secure=false, expires =none, discard=true, comment=none, comment_url=none, rest={}, rfc2109=false), co okie(version=0, name='websecu', value='f', port=none, port_specified=false, doma in='localhost.local...
Read more