u/emmpressive

Hi all, got the idea to open up my kitchen, the room that I am above in the video, to my living room. My plan is to remove the vertical wall in the video, keeping only the post that holds up the beam. Have a couple questions before I change anything:

1. Aside from the post in the wall under the beam, is the rest of the wall load bearing?
2. How should I support the kitchen ceiling with the wall gone? Can I remove the lower portion of the wall below the ceiling joists and keep the upper portion between the joists and rafters?

https://imgur.com/a/tr4vLM9